Stories
Slash Boxes
Comments

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jhorwitz (4227)

jhorwitz
  reversethis-{gro.gnihsams} {ta} {ffej}
http://www.smashing.org/

System administrator, Perl hacker, author of "Unix System Management Primer Plus" (SAMS 2003), mod_parrot, extproc_perl, Authen::Krb4, Authen::Krb5.

Journal of jhorwitz (4227)

Monday August 04, 2003
10:13 PM

extproc_parrot is born

[ #13911 ]
I am a sick, sick individual. After a spending a couple of days swimming around the Parrot source, I was finally able to write a proof-of-concept library that embeds Parrot in Oracle. extproc_parrot is born. Squawk. SQUAWK!

# hello.pasm
# Sets S31 to "Hello, name", where name is the
# first argument to parrot

main:   set S0, "Hello, "
        set S1, P0[1]
        concat S0, S1
        set S31, S0

SQL> select parrot('hello','Jeff') from dual;

PARROT('HELLO','JEFF')
----------------------
Hello, Jeff

Woohoo! Hm, I should try writing a function in BASIC targeted to Parrot... ;-)

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • sdafdsafdsafsdafsadfsa
    • Sorry, couldn't get my keyboard to work; guess I could use a new one. :-)

      Is there an extproc_php? It may be of no interest to this community, but it seems worth adding to your list of languages; maybe you can extproc them all. :-)

      • I don't think there is any such module available for Oracle, although there has been a beta release of a plPHP extension for Postgres - Details are available here [commandprompt.com].
      • Keyboard, eh? I just thought you were drunk... ;-) The significance of extproc_parrot is that any language that can be targeted to parrot can be embedded in Oracle. So if someone targets PHP to parrot, it should just work. I know some Ruby people were interested in an extproc_ruby, and this is one way to do something like that. Things like callbacks (accessing the calling database from your code) need to be patched in like I do with DBD::Oracle, but that's fairly trivial.