2
Bug #40078 (ORA-01405 when fetching NULL values using oci_bind_array_by_name())
4
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
8
require dirname(__FILE__).'/connect.inc';
11
CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS
12
TYPE ARRTYPE IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;
13
PROCEDURE nullbind(c1 OUT ARRTYPE);
15
$statement = oci_parse($c, $create_pkg);
16
oci_execute($statement);
19
CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS
20
PROCEDURE nullbind(c1 OUT ARRTYPE) IS
29
$statement = oci_parse($c, $create_pkg_body);
30
oci_execute($statement);
32
$statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.nullbind(:c1); END;");
34
oci_bind_array_by_name($statement, ":c1", $array, 5, 20, SQLT_CHR);
36
oci_execute($statement);