odbc_procedurecolumns

Description

resource odbc_procedurecolumns ( resource connection_id [, string qualifier [, string owner [, string proc [, string column]]]])

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures_ Returns an ODBC result identifier or FALSE on failure_

The result set has the following columns:

• PROCEDURE_QUALIFIER

• PROCEDURE_OWNER

• PROCEDURE_NAME

• COLUMN_NAME

• COLUMN_TYPE

• DATA_TYPE

• TYPE_NAME

• PRECISION

• LENGTH

• SCALE

• RADIX

• NULLABLE

• REMARKS

The result set is ordered by PROCEDURE_QUALIFIER, PROCEDURE_OWNER, PROCEDURE_NAME and COLUMN_TYPE_

The owner, proc and column arguments accept search patterns ('%' to match zero or more characters and '_' to match a single character)_