odbc_procedurecolumns

Retrieve information about parameters to procedures

 **odbc_procedurecolumns** Odbc\Connection $odbc  $catalog  $schema  $procedure  $column

Retrieve information about parameters to procedures.

odbc``catalogodbc.parameter.catalog

schemaodbc.parameter.schema odbc.parameter.search

procedureThe proc. odbc.parameter.search

columnThe column. odbc.parameter.search

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. odbc.result.object-return-falseforfailure

The result set has the following columns:

odbc.result.driver-specific

PROCEDURE_CAT
PROCEDURE_SCHEM
PROCEDURE_NAME
COLUMN_NAME
COLUMN_TYPE
DATA_TYPE
TYPE_NAME
COLUMN_SIZE
BUFFER_LENGTH
DECIMAL_DIGITS
NUM_PREC_RADIX
NULLABLE
REMARKS
COLUMN_DEF
SQL_DATA_TYPE
SQL_DATETIME_SUB
CHAR_OCTET_LENGTH
ORDINAL_POSITION
IS_NULLABLE

The result set is ordered by , , and . PROCEDURE_CAT``PROCEDURE_SCHEM``PROCEDURE_NAME``COLUMN_TYPE

Voorbeeld: List Columns of a stored Procedure

<?php
$conn = odbc_connect($dsn, $user, $pass);
$columns = odbc_procedurecolumns($conn, 'TutorialDB', 'dbo', 'GetEmployeeSalesYTD;1', '%');
while (($row = odbc_fetch_array($columns))) {
    print_r($row);
    break; // further rows omitted for brevity
}
?>

Array
(
    [PROCEDURE_CAT] => TutorialDB
    [PROCEDURE_SCHEM] => dbo
    [PROCEDURE_NAME] => GetEmployeeSalesYTD;1
    [COLUMN_NAME] => @SalesPerson
    [COLUMN_TYPE] => 1
    [DATA_TYPE] => -9
    [TYPE_NAME] => nvarchar
    [COLUMN_SIZE] => 50
    [BUFFER_LENGTH] => 100
    [DECIMAL_DIGITS] =>
    [NUM_PREC_RADIX] =>
    [NULLABLE] => 1
    [REMARKS] =>
    [COLUMN_DEF] =>
    [SQL_DATA_TYPE] => -9
    [SQL_DATETIME_SUB] =>
    [CHAR_OCTET_LENGTH] => 100
    [ORDINAL_POSITION] => 1
    [IS_NULLABLE] => YES
)

odbc_columns

Vorige ← odbc_primarykeys Volgende odbc_procedures →

odbc_procedurecolumns

odbc_procedurecolumns

Documentatie