python-database

skip at pobox.com skip at pobox.com
Mon Sep 4 08:28:04 EDT 2006


    Cliff> On Sun, 2006-09-03 at 21:30 -0700, sridhar wrote:
    >> is there any way to call stored procedures from python as in java?

    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



More information about the Python-list mailing list