Re: pl/sql alternatives for server side programming?
Date: Fri, 24 Oct 2008 15:22:34 -0700 (PDT)
Message-ID: <44e828ad-984f-496e-9d54-84bdd0bae490@k16g2000hsf.googlegroups.com>
On Oct 24, 4:56 pm, m..._at_pixar.com wrote:
> 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
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/B19306_01/server.102/b14200/statements_5009.htm#i2153260
and look at syntax : LANGUAGE ...
More info about java SP:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_environments.htm#sthref78
HTH
Thomas
Received on Fri Oct 24 2008 - 17:22:34 CDT