diff options
Diffstat (limited to 'ext/oci8/tests/array_bind_004.phpt')
-rw-r--r-- | ext/oci8/tests/array_bind_004.phpt | 65 |
1 files changed, 0 insertions, 65 deletions
diff --git a/ext/oci8/tests/array_bind_004.phpt b/ext/oci8/tests/array_bind_004.phpt deleted file mode 100644 index 1ddf85149b..0000000000 --- a/ext/oci8/tests/array_bind_004.phpt +++ /dev/null @@ -1,65 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 4 ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$drop = "DROP table bind_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -$create = "CREATE table bind_test(name DATE)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF DATE INDEX BY BINARY_INTEGER; - PROCEDURE iobind(c1 IN OUT ARRTYPE); -END ARRAYBINDPKG1;"; -$statement = oci_parse($c, $create_pkg); -oci_execute($statement); - -$create_pkg_body = " -CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS - CURSOR CUR IS SELECT name FROM bind_test; - PROCEDURE iobind(c1 IN OUT ARRTYPE) IS - BEGIN - FOR i IN 1..5 LOOP - INSERT INTO bind_test VALUES (c1(i)); - END LOOP; - IF NOT CUR%ISOPEN THEN - OPEN CUR; - END IF; - FOR i IN REVERSE 1..5 LOOP - FETCH CUR INTO c1(i); - IF CUR%NOTFOUND THEN - CLOSE CUR; - EXIT; - END IF; - END LOOP; - END iobind; -END ARRAYBINDPKG1;"; -$statement = oci_parse($c, $create_pkg_body); -oci_execute($statement); - -$statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;"); - -$array = Array(); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_ODT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_execute(): OCI_NO_DATA in %s on line %d -array(0) { -} -Done |