oci_bind_array_by_name

Function • Removed in PHP 8.4

Binds a PHP array to an Oracle PL/SQL array parameter.

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

oci_bind_array_by_name Function synopsis

oci_bind_array_by_name(
    $statement,
    string $param,
    &$var,
    int $max_array_length,
    int $max_item_length = -1,
    int $type = SQLT_AFC
  ): bool

Parameters

$statement

A valid OCI statement identifier.

$param

Typestring

The Oracle placeholder.

$var

Passed by reference

An array.

$max_array_length

Typeint

Sets the maximum length both for incoming and result arrays.

$max_item_length

OptionalTypeintDefault value-1

Sets maximum length for array items. If not specified or equals to -1, oci_bind_array_by_name will find the longest element in the incoming array and will use it as the maximum length.

$type

OptionalTypeintDefault valueSQLT_AFC

Should be used to set the type of PL/SQL array items. See list of available types below:

Note that the parameter $var is passed by reference, and contains additional/updated context data that may be useful.

Return value

Typebool

Returns true on success, false on failure

Changes to the oci_bind_array_by_name Function

PHP 8.4

  • Function removed

PHP 8.0

  • Return type added: bool
  • Parameter name of parameter #1 changed: $statement_resource to $statement
  • Parameter name of parameter #2 changed: $column_name to $param
  • Parameter type added for parameter #2 ($param): string
  • Parameter name of parameter #3 changed: $variable to $var
  • Parameter name of parameter #4 changed: $maximum_array_length to $max_array_length
  • Parameter type added for parameter #4 ($max_array_length): int
  • Parameter name of parameter #5 changed: $maximum_item_length to $max_item_length
  • Parameter type added for parameter #5 ($max_item_length): int
  • Parameter default value added for position #5 ($max_item_length): -1
  • Parameter type added for parameter #6 ($type): int
  • Parameter default value added for position #6 ($type): SQLT_AFC
  oci_bind_array_by_name(
-     $statement_resource,
+     $statement,
-     $column_name,
+     string $param,
-     &$variable,
+     &$var,
-     $maximum_array_length,
+     int $max_array_length,
-     $maximum_item_length,
+     int $max_item_length = -1,
-     $type
+     int $type = SQLT_AFC
-   )
+   ): bool

oci_bind_array_by_name Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release No
PHP 8.5Supported (Latest) No
PHP 8.4Supported No
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