odbc_procedurecolumns

(PHP 4, PHP 5)

odbc_procedurecolumns — Retrieve information about parameters to procedures

說明

resource odbc_procedurecolumns ( resource $connection_id )

resource odbc_procedurecolumns ( resource $connection_id , string $qualifier , string $owner , string $proc , string $column )

Retrieve information about parameters to procedures.

參數

connection_id: ODBC 連線標識符，詳見 odbc_connect()。
qualifier: The qualifier.
owner: The owner. 此參數接受下列查詢模式："%" 來匹配零到多個字元，"_" 來匹配單個字元。
proc: The proc. 此參數接受下列查詢模式："%" 來匹配零到多個字元，"_" 來匹配單個字元。
column: The 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 或者在失敗時回傳 FALSE.

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.

add a note

User Contributed Notes

There are no user contributed notes for this page.