Python as a replacement to PL/SQL

[Alec Taylor]

Hmm...

What else is there besides PL/Python (for any DB) in the context of
writing stored procedures in function?

Thanks for all suggestions,

Alec Taylor

On Tue, Oct 25, 2011 at 1:45 AM, Alain Ketterlin
<alain at dpt-info.u-strasbg.fr> wrote:
> Alec Taylor <alec.taylor6 at gmail.com> writes:
>
>> Is there a set of libraries for python which can be used as a complete
>> replacement to PL/SQL?
>
> This doesn't make much sense: PL/SQL lets you write server-side code,
> i.e., executed by the DBMS. Oracle can't execute python code directly,
> so python can only be used on the client side (I meant "client of the
> DBMS"), i.e., not to write stored procedures. There is no "complete
> replacement" of PL/SQL besides Java.
>
> This page shows you how to _call_ PL/SQL procedures from a python script:
>
> http://www.oracle.com/technetwork/articles/dsl/python-091105.html
>
>> (I am speaking from the context of Oracle DB, PL/Python only works
>> with PostgreSQL)
>
> PL/Python is a different beast, it lets you write stored functions in
> python. There is no such thing, afaik, with Oracle.
>
> -- Alain.
> --
> http://mail.python.org/mailman/listinfo/python-list
>