Re: pl/sql alternatives for server side programming?

On 25 oct, 00:28, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> Thomas Olszewicki (Thom..._at_cpas.com) wrote:
>
> : On Oct 24, 4:56=A0pm, 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? =A0Can 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/statem...
> : 009.htm#i2153260
> : and look at syntax : LANGUAGE ...
>
> I thought they had de-supported the use of C routines as stored
> procedures.

I seem to remember some utility to write SP's in any MS language (VB included, Oh my!). I took care to keep this thing very far from my databases...

Cheers.

Carlos. Received on Mon Oct 27 2008 - 03:14:43 CDT