Installation guide

mxODBC - Python ODBC Database Interface
5.4 Thread Safety & Thread Friendliness ................................. 66
5.4.1 Connections and Cursors..................................................................... 66
5.4.2 Unlocking the Python Global Interpreter Lock (GIL)............................. 66
5.4.3 Threading Support ............................................................................... 66
5.5 Transaction Support.......................................................... 66
5.5.1 Auto-Commit....................................................................................... 66
5.5.2 Manual Commit................................................................................... 67
Transaction Start and End ...............................................................67
Data Sources without Transaction Support ..................................... 67
5.5.3 Adjusting the Connection Commit Mode............................................. 68
5.6 Stored Procedures............................................................. 68
5.6.1 Calling Stored Procedures with .callproc() ........................................... 68
Retrieving output parameters from stored procedures.................... 69
Retrieving result sets from stored procedures................................. 69
5.6.2 Calling Stored Procedures with cursor.execute*() Methods ................. 69
Retrieving output parameters from stored procedures.................... 70
Retrieving result sets from stored procedures................................. 71
5.6.3 Input/Output and Output Parameters .................................................. 71
parametertypes Parameter.............................................................. 71
SQL.PARAM_INPUT .................................................................. 72
SQL.PARAM_OUTPUT............................................................... 72
SQL.PARAM_INPUT_OUTPUT ..................................................72
Dynamically determining the Parameter Type................................. 72
5.6.4 Special constraints of some ODBC drivers........................................... 73
Mixing output parameters and output result sets............................ 73
Using None as value for output parameters.................................... 73
5.6.5 Using Result Sets for passing back Output Data .................................. 74
Using result sets to pass back output data ...................................... 74
MS SQL Server and Sybase ASE Cursors in Stored Procedures........ 74
Oracle Ref Cursors as Output Parameters....................................... 75
IBM DB2 Cursors in Stored Procedures .......................................... 75
PostgreSQL Cursors in Stored Procedures ...................................... 75
5.6.6 SQL Output Statements in Stored Procedures...................................... 76
5.7 Introspection..................................................................... 76