Stored Procedures (ODBC) from Python?

[rapto at my-deja.com]

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/