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 <al...@dpt-info.u-strasbg.fr> wrote: > Alec Taylor <alec.tayl...@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 > -- http://mail.python.org/mailman/listinfo/python-list
