Stored Procedures (ODBC) from Python?

rapto at my-deja.com rapto at my-deja.com
Mon Dec 18 20:09:56 CET 2000


The standard ODBC idiom for calling stored procedures (or saved
parameter queries in Access) is
{call MyStoredProc(arg1, arg2...)}

For example:

{call getOrderId('9/312')}

You may look for documentation for ODBC escape sequences. There are some
for dates, outer joins, concatenating strings, data type conversion,
parameter return, etc.

Using these you may get a bit more vendor-independent.


Sent via Deja.com
http://www.deja.com/



More information about the Python-list mailing list