Python as a replacement to PL/SQL

[Martin Komoň]

PostgreSQL supports PL/SQL, PL/TCL, PL/Python, PL/Perl and I've also
seen PL/Java add on module.

Martin

On 10/24/2011 4:59 PM, Alec Taylor wrote:
> 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
>>