python-database

[sridhar]

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

 

[Cliff Wells]

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]

Cliff> I mostly use PostgreSQL, so perhaps it's different for some other
Cliff> databases, but calling stored procedures doesn't require any
Cliff> special support from the language or driver. Usually you simply
Cliff> SELECT 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

 

[Dennis Lee Bieber]

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

If the database itself supports multiple result sets, then the
db-api implementation should support the optional

cursor.nextset()

method (Note: I believe that's a one-way street -- better fetch all data
from one set before asking for the next one)
--
Wulfraed Dennis Lee Bieber KD6MOG
(e-mail address removed) (e-mail address removed)
HTTP://wlfraed.home.netcom.com/
(Bestiaria Support Staff: (e-mail address removed))
HTTP://www.bestiaria.com/