If you look at postgresql, they have the idea of pluggable scripting
languages, so you can write server side code in tcl, python, etc.

Is there an equivalent idea in Oracle?
Are there any alternatives to PL/SQL for Oracle server-side programming?
Can java be used? Can PL/SQL procedures be bound to compiled C code?

Is this just too weird to even think about?

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

mh (AT) pixar (DOT) com wa:
Yes, Java. From 8i, I think(?).
http://www.oracle.com/technology/sam...acle9ijsp.html
http://www.developer.com/db/article.php/3337411
http://www.devarticles.com/c/a/Java/...e-Interaction/


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

mh (AT) pixar (DOT) com wa:
Yes, Java. From 8i, I think(?).
http://www.oracle.com/technology/sam...acle9ijsp.html
http://www.developer.com/db/article.php/3337411
http://www.devarticles.com/c/a/Java/...e-Interaction/


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

mh (AT) pixar (DOT) com wa:
Yes, Java. From 8i, I think(?).
http://www.oracle.com/technology/sam...acle9ijsp.html
http://www.developer.com/db/article.php/3337411
http://www.devarticles.com/c/a/Java/...e-Interaction/


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

mh (AT) pixar (DOT) com wa:
Yes, Java. From 8i, I think(?).
http://www.oracle.com/technology/sam...acle9ijsp.html
http://www.developer.com/db/article.php/3337411
http://www.devarticles.com/c/a/Java/...e-Interaction/


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

<mh (AT) pixar (DOT) com> wrote

You can write in C and then call it from within pl/sql. You can compile
pl/sql code to native code. (You write it in pl/sql and then have it compile
natively) You could write it in C and call the db for data. What are you
trying to accomplish?
Jim

<mh (AT) pixar (DOT) com> wrote

You can write in C and then call it from within pl/sql. You can compile
pl/sql code to native code. (You write it in pl/sql and then have it compile
natively) You could write it in C and call the db for data. What are you
trying to accomplish?
Jim

<mh (AT) pixar (DOT) com> wrote

You can write in C and then call it from within pl/sql. You can compile
pl/sql code to native code. (You write it in pl/sql and then have it compile
natively) You could write it in C and call the db for data. What are you
trying to accomplish?
Jim

<mh (AT) pixar (DOT) com> wrote

You can write in C and then call it from within pl/sql. You can compile
pl/sql code to native code. (You write it in pl/sql and then have it compile
natively) You could write it in C and call the db for data. What are you
trying to accomplish?
Jim

On Oct 24, 4:56*pm, m... (AT) pixar (DOT) com wrote:
Mark
Oracle supports Stored procedures in pl/sql, Java and C
Look up definition and examples of for example FUNCTION:
http://download.oracle.com/docs/cd/B...9.htm#i2153260
and look at syntax : LANGUAGE ...

More info about java SP:
http://download.oracle.com/docs/cd/B...s.htm#sthref78

HTH
Thomas