Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
SQL.PT_PROCEDURE: The returned object
is a procedure; that is, it does not have a
return value.
SQL.PT_FUNCTION: The returned object
is a function; that is, it has a return value.
.procedurecolumns(qualifier=None, owner=None, procedure=None,
column=None)
Query the data source for information on parameter details of procedures
stored in a data source.
procedure can be used to limit the results to a set of procedures or a single
procedure.
column allows restricting the results to a single procedure
parameter.
The method can be used to e.g. determine whether a parameter is an input,
output or input/output parameter. The COLUMN_TYPE column information can
directly be passed to the
parametertypes parameter in cursor.callproc()
and the
cursor.execute*() methods.
The catalog method generates a result set having the following schema (the
term "column" used here refers to the procedure's call parameters):
Column Name Column Datatype Comment
PROCEDURE_CAT VARCHAR(128) Always NULL.
PROCEDURE_
SCHEMA
VARCHAR(128) The name of the schema containing
PROCEDURE_NAME.
PROCEDURE_
NAME
VARCHAR(128) The name of the table, or view, or alias, or
synonym.
COLUMN_NAME VARCHAR(128) Name of the column of the specified table, view,
alias, or synonym.
COLUMN_TYPE SMALLINT not NULL Identifies the type information associated with
this column. Possible values:
SQL.PARAM_TYPE_UNKNOWN: the parameter
type is unknown.
SQL.PARAM_INPUT: this parameter is an input
parameter.
SQL.PARAM_INPUT_OUTPUT: this parameter is
an input / output parameter.
125