python-database

[sridhar]

is there any way to call stored procedures from python as in java?

[Cliff Wells]

On Sun, 2006-09-03 at 21:30 -0700, sridhar wrote:

is there any way to call stored procedures from python as in java?

I mostly use PostgreSQL, so perhaps it's different for some other
databases, but calling stored procedures doesn't require any special
support from the language or driver. Usually you simply SELECT from the
stored procedure.

Also, you might be interested to know that with PostgreSQL you can also
*write* stored procedures in Python which I consider a huge plus.

Regards,
Cliff

--

[skip]

CliffOn Sun, 2006-09-03 at 21:30 -0700, sridhar wrote:

>is there any way to call stored procedures from python as in java?

CliffI mostly use PostgreSQL, so perhaps it's different for some other
Cliffdatabases, but calling stored procedures doesn't require any
Cliffspecial support from the language or driver. Usually you simply
CliffSELECT from the stored procedure.

In a stored procedure you can execute multiple SELECTs. On the receiving
end you need some way to distinguish each result set.

Skip