Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #14924

Re: Python as a replacement to PL/SQL

Show all headers | View raw

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