PHP Manual
Prev |  | Next

# odbc_procedurecolumns

(PHP 4 )

odbc_procedurecolumns -- Retrieve information about parameters to procedures

## 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).

Prev | Home | Next
odbc_primarykeys | Up | odbc_procedures