Re: pl/sql alternatives for server side programming?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 26 Oct 2008 12:43:13 +0100
Message-ID: <4f571$490457d1$524b5c40$9006@cache4.tilbu1.nb.home.nl>


mh_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
>

All these are external to the database, if memory serves. pl/sql and java are internal to Oracles' rdbms, and java, C, Fortran and Cobol are external with their own pre-compilers. PHP is being embraced by Oracle, so it seems.

Then, there's the mirade of languages, that can communicate with the rdbms using one of the connection techniques.

Ruby is known in Oracle world
(http://delicious.com/OracleTechnologyNetwork/jruby) and is basically connecting to Oracle, using jdbc. Should not be a problem.

-- 

Regards,
Frank van Bortel
Received on Sun Oct 26 2008 - 06:43:13 CDT

Original text of this message