odbc_procedurecolumns

Function • Params and return types changed in PHP 8.4

Retrieve information about parameters to procedures.

PHP 5
PHP 7
PHP 8.0
Improved
PHP 8.1
PHP 8.2-8.3
PHP 8.4
Improved
PHP 8.5
PHP 8.6

odbc_procedurecolumns Function synopsis

odbc_procedurecolumns(
    Odbc\Connection $odbc,
    ?string $catalog = null,
    ?string $schema = null,
    ?string $procedure = null,
    ?string $column = null
  ): Odbc\Result|false

Parameters

$odbc

TypeOdbc\Connection

$catalog

OptionalType?stringDefault valuenull

The catalog ("qualifier" in ODBC 2 parlance).

$schema

OptionalType?stringDefault valuenull

The schema ("owner" in ODBC 2 parlance). This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

$procedure

OptionalType?stringDefault valuenull

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

$column

OptionalType?stringDefault valuenull

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

Return value

TypeOdbc\Result|false

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 object or false on failure

The result set has the following columns:

Drivers can report additional columns.

Changes to the odbc_procedurecolumns Function

PHP 8.4

  • Return type added: Odbc\Result|false
  • Parameter type added for parameter #1 ($odbc): Odbc\Connection
  odbc_procedurecolumns(
-     $odbc,
+     Odbc\Connection $odbc,
      ?string $catalog = null,
      ?string $schema = null,
      ?string $procedure = null,
      ?string $column = null
-   )
+   ): Odbc\Result|false

PHP 8.0

  • Parameter name of parameter #1 changed: $connection_id to $odbc
  • Parameter name of parameter #2 changed: $qualifier to $catalog
  • Parameter type added for parameter #2 ($catalog): ?string
  • Parameter default value added for position #2 ($catalog): null
  • Parameter name of parameter #3 changed: $owner to $schema
  • Parameter type added for parameter #3 ($schema): ?string
  • Parameter default value added for position #3 ($schema): null
  • Parameter name of parameter #4 changed: $proc to $procedure
  • Parameter type added for parameter #4 ($procedure): ?string
  • Parameter default value added for position #4 ($procedure): null
  • Parameter type added for parameter #5 ($column): ?string
  • Parameter default value added for position #5 ($column): null
  odbc_procedurecolumns(
-     $connection_id,
+     $odbc,
-     $qualifier,
+     ?string $catalog = null,
-     $owner,
+     ?string $schema = null,
-     $proc,
+     ?string $procedure = null,
-     $column
+     ?string $column = null
    )

odbc_procedurecolumns Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release Yes
PHP 8.5Supported (Latest) Yes
PHP 8.4Supported Yes
PHP 8.3Security-Fixes Only Yes
PHP 8.2Security-Fixes Only Yes
PHP 8.1Unsupported Yes
PHP 8.0Unsupported Yes
PHP 7.4Unsupported Yes
PHP 7.3Unsupported Yes
PHP 7.2Unsupported Yes
PHP 7.1Unsupported Yes
PHP 7.0Unsupported Yes
PHP 5.6Unsupported Yes
PHP 5.5Unsupported Yes
PHP 5.4Unsupported Yes
PHP 5.3Unsupported Yes