PHP 7.0.6 Released

    odbc_procedurecolumns

    (PHP 4, PHP 5, PHP 7)

    odbc_procedurecolumns — Retrieve information about parameters to procedures

    Description

    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.

    Parameters

    connection_id

    The ODBC connection identifier, see odbc_connect() for details.

    qualifier

    The qualifier.

    owner

    The owner. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a single character.

    proc

    The proc. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a single character.

    column

    The column. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a single character.

    Return Values

    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.

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top