Re: Python as a replacement to PL/SQL

Date	2011-10-24 18:37 +0200
From	Martin Komoň <M.Komon@SiliconHill.cz>
Subject	Re: Python as a replacement to PL/SQL
References	<mailman.2176.1319463553.27778.python-list@python.org> <87bot6sb2j.fsf@dpt-info.u-strasbg.fr> <CAO+9iGe5sWHyFUarRQ8C-b0ZtK7ogyxf6YBongjo6ocb72Uogg@mail.gmail.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.2184.1319474262.27778.python-list@python.org> (permalink)

Show all headers | View raw

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@dpt-info.u-strasbg.fr> wrote:
>> Alec Taylor <alec.taylor6@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
>>

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Python as a replacement to PL/SQL Alec Taylor <alec.taylor6@gmail.com> - 2011-10-25 00:39 +1100
  Re: Python as a replacement to PL/SQL Alain Ketterlin <alain@dpt-info.u-strasbg.fr> - 2011-10-24 16:45 +0200
    Re: Python as a replacement to PL/SQL Alec Taylor <alec.taylor6@gmail.com> - 2011-10-25 01:59 +1100
      Re: Python as a replacement to PL/SQL Ben Finney <ben+python@benfinney.id.au> - 2011-10-25 08:36 +1100
    Re: Python as a replacement to PL/SQL Martin Komoň <M.Komon@SiliconHill.cz> - 2011-10-24 18:37 +0200

csiph-web