diff options
Diffstat (limited to 'ext/oci8/tests')
162 files changed, 0 insertions, 9106 deletions
diff --git a/ext/oci8/tests/array_bind_001.phpt b/ext/oci8/tests/array_bind_001.phpt deleted file mode 100644 index 1310325ad4..0000000000 --- a/ext/oci8/tests/array_bind_001.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 1 ---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 = ""; - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_ODT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): OCI-21560: argument 3 is null, invalid, or out of range in %s on line %d - -Warning: oci_execute(): ORA-01008: not all variables bound in %s on line %d -array(1) { - [0]=> - string(0) "" -} -Done diff --git a/ext/oci8/tests/array_bind_002.phpt b/ext/oci8/tests/array_bind_002.phpt deleted file mode 100644 index 4c76df42f9..0000000000 --- a/ext/oci8/tests/array_bind_002.phpt +++ /dev/null @@ -1,77 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 2 ---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("06-DEC-05","10-DEC-80","21-AUG-91","26-OCT-17","05-NOV-05"); - -oci_bind_array_by_name($statement, ":c1", $array, 0, 0, SQLT_ODT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): Maximum array length must be greater than zero in %s on line %d - -Warning: oci_execute(): ORA-01008: not all variables bound in %s on line %d -array(5) { - [0]=> - string(9) "06-DEC-05" - [1]=> - string(9) "10-DEC-80" - [2]=> - string(9) "21-AUG-91" - [3]=> - string(9) "26-OCT-17" - [4]=> - string(9) "05-NOV-05" -} -Done diff --git a/ext/oci8/tests/array_bind_003.phpt b/ext/oci8/tests/array_bind_003.phpt deleted file mode 100644 index 497e46e496..0000000000 --- a/ext/oci8/tests/array_bind_003.phpt +++ /dev/null @@ -1,73 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 3 ---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("06-DEC-05","10-DEC-80","21-AUG-91","26-OCT-17"); - -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(4) { - [0]=> - string(9) "06-DEC-05" - [1]=> - string(9) "10-DEC-80" - [2]=> - string(9) "21-AUG-91" - [3]=> - string(9) "26-OCT-17" -} -Done 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 diff --git a/ext/oci8/tests/array_bind_005.phpt b/ext/oci8/tests/array_bind_005.phpt deleted file mode 100644 index 15278532ea..0000000000 --- a/ext/oci8/tests/array_bind_005.phpt +++ /dev/null @@ -1,75 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 5 ---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 VARCHAR(20))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF VARCHAR(20) 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, 20, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_execute(): ORA-01405: fetched column value is NULL in %s on line %d -array(5) { - [0]=> - string(0) "" - [1]=> - string(0) "" - [2]=> - string(0) "" - [3]=> - string(0) "" - [4]=> - string(0) "" -} -Done diff --git a/ext/oci8/tests/array_bind_006.phpt b/ext/oci8/tests/array_bind_006.phpt deleted file mode 100644 index e229dd8722..0000000000 --- a/ext/oci8/tests/array_bind_006.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name(), SQLT_CHR and default max_length ---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 VARCHAR(20))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF VARCHAR(20) 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("one", "two", "three", "four", "five"); - -oci_bind_array_by_name($statement, ":c1", $array, 5, -1, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - string(4) "five" - [1]=> - string(4) "four" - [2]=> - string(5) "three" - [3]=> - string(3) "two" - [4]=> - string(3) "one" -} -Done diff --git a/ext/oci8/tests/array_bind_007.phpt b/ext/oci8/tests/array_bind_007.phpt deleted file mode 100644 index 10c92a8e7d..0000000000 --- a/ext/oci8/tests/array_bind_007.phpt +++ /dev/null @@ -1,77 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 7 ---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 NUMBER)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF NUMBER 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(1,2,3,4,5); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, -1); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): Unknown or unsupported datatype given: -1 in %s on line %d - -Warning: oci_execute(): ORA-01008: not all variables bound in %s on line %d -array(5) { - [0]=> - int(1) - [1]=> - int(2) - [2]=> - int(3) - [3]=> - int(4) - [4]=> - int(5) -} -Done diff --git a/ext/oci8/tests/array_bind_008.phpt b/ext/oci8/tests/array_bind_008.phpt deleted file mode 100644 index c44304c11c..0000000000 --- a/ext/oci8/tests/array_bind_008.phpt +++ /dev/null @@ -1,78 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 8 ---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 NUMBER)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF NUMBER 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(1,2,3,4,5); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_execute(): ORA-06550: line %d, column %d: -PLS-00418: array bind type must match PL/SQL table row type -ORA-06550: line %d, column %d: -PL/SQL: Statement ignored in %s on line %d -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" - [2]=> - string(1) "3" - [3]=> - string(1) "4" - [4]=> - string(1) "5" -} -Done diff --git a/ext/oci8/tests/array_bind_009.phpt b/ext/oci8/tests/array_bind_009.phpt deleted file mode 100644 index 8e83b0982c..0000000000 --- a/ext/oci8/tests/array_bind_009.phpt +++ /dev/null @@ -1,17 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 9 ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -var_dump(oci_bind_array_by_name($c, ":c1", $array, 5, 5, SQLT_CHR)); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/array_bind_010.phpt b/ext/oci8/tests/array_bind_010.phpt deleted file mode 100644 index a77ed913ea..0000000000 --- a/ext/oci8/tests/array_bind_010.phpt +++ /dev/null @@ -1,36 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and invalid values 8 ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$statement = oci_parse($c, 'SELECT user FROM v$session'); - -$array = Array(1,2,3,4,5); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): ORA-01036: illegal variable name/number in %s on line %d -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" - [2]=> - string(1) "3" - [3]=> - string(1) "4" - [4]=> - string(1) "5" -} -Done diff --git a/ext/oci8/tests/array_bind_011.phpt b/ext/oci8/tests/array_bind_011.phpt deleted file mode 100644 index e8e00a8091..0000000000 --- a/ext/oci8/tests/array_bind_011.phpt +++ /dev/null @@ -1,67 +0,0 @@ ---TEST-- -oci_bind_array_by_name(), SQLT_CHR, default max_length and empty array ---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 VARCHAR(20))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF VARCHAR(20) 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, -1, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): You must provide max length value for empty arrays in %s on line %d - -Warning: oci_execute(): ORA-01008: not all variables bound in %s on line %d -array(0) { -} -Done diff --git a/ext/oci8/tests/array_bind_012.phpt b/ext/oci8/tests/array_bind_012.phpt deleted file mode 100644 index 2208f0b3b9..0000000000 --- a/ext/oci8/tests/array_bind_012.phpt +++ /dev/null @@ -1,26 +0,0 @@ ---TEST-- -oci_bind_array_by_name(), SQLT_CHR, default max_length and empty array ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$statement = oci_parse($c, 'SELECT user FROM v$session'); - -$array = array(); - -oci_bind_array_by_name($statement, ":c1", $array, 5, -10, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name(): Invalid max length value (-10) in %s on line %d -array(0) { -} -Done diff --git a/ext/oci8/tests/array_bind_013.phpt b/ext/oci8/tests/array_bind_013.phpt deleted file mode 100644 index da8f6fdd1a..0000000000 --- a/ext/oci8/tests/array_bind_013.phpt +++ /dev/null @@ -1,39 +0,0 @@ ---TEST-- -oci_bind_array_by_name(), SQLT_CHR, default max_length and empty array ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$statement = oci_parse($c, 'SELECT user FROM v$session'); - -$array = array(); - -var_dump(oci_bind_array_by_name($statement, ":c1", $array, 5, -10, SQLT_CHR, -10)); -var_dump(oci_bind_array_by_name($statement, ":c1", $array, 5, -10)); -var_dump(oci_bind_array_by_name($statement, ":c1", $array, 5, -1)); -var_dump(oci_bind_array_by_name($statement, ":c1", $array, 5, 0)); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_bind_array_by_name() expects at most 6 parameters, 7 given in %s on line %d -NULL - -Warning: oci_bind_array_by_name(): You must provide max length value for empty arrays in %s on line %d -bool(false) - -Warning: oci_bind_array_by_name(): You must provide max length value for empty arrays in %s on line %d -bool(false) - -Warning: oci_bind_array_by_name(): You must provide max length value for empty arrays in %s on line %d -bool(false) -array(0) { -} -Done diff --git a/ext/oci8/tests/array_bind_date.phpt b/ext/oci8/tests/array_bind_date.phpt deleted file mode 100644 index 63da558f91..0000000000 --- a/ext/oci8/tests/array_bind_date.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_ODT ---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("06-DEC-05","10-DEC-80","21-AUG-91","26-OCT-17","05-NOV-05"); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_ODT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - string(9) "05-NOV-05" - [1]=> - string(9) "26-OCT-17" - [2]=> - string(9) "21-AUG-91" - [3]=> - string(9) "10-DEC-80" - [4]=> - string(9) "06-DEC-05" -} -Done diff --git a/ext/oci8/tests/array_bind_date1.phpt b/ext/oci8/tests/array_bind_date1.phpt deleted file mode 100644 index ebf767570b..0000000000 --- a/ext/oci8/tests/array_bind_date1.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_ODT ---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("06-DEC-05","10-DEC-80","21-AUG-91","26-OCT-17","05-NOV-05"); - -oci_bind_array_by_name($statement, ":c1", $array, 10, 5, SQLT_ODT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - string(9) "05-NOV-05" - [1]=> - string(9) "26-OCT-17" - [2]=> - string(9) "21-AUG-91" - [3]=> - string(9) "10-DEC-80" - [4]=> - string(9) "06-DEC-05" -} -Done diff --git a/ext/oci8/tests/array_bind_float.phpt b/ext/oci8/tests/array_bind_float.phpt deleted file mode 100644 index 1aafb24317..0000000000 --- a/ext/oci8/tests/array_bind_float.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_FLT ---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 FLOAT)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF FLOAT 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(1.243,2.5658,3.4234,4.2123,5.9999); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_FLT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - float(5.9999) - [1]=> - float(4.2123) - [2]=> - float(3.4234) - [3]=> - float(2.5658) - [4]=> - float(1.243) -} -Done diff --git a/ext/oci8/tests/array_bind_float1.phpt b/ext/oci8/tests/array_bind_float1.phpt deleted file mode 100644 index ead85890fa..0000000000 --- a/ext/oci8/tests/array_bind_float1.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_FLT ---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 FLOAT)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF FLOAT 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(1.243,2.5658,3.4234,4.2123,5.9999); - -oci_bind_array_by_name($statement, ":c1", $array, 10, 5, SQLT_FLT); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - float(5.9999) - [1]=> - float(4.2123) - [2]=> - float(3.4234) - [3]=> - float(2.5658) - [4]=> - float(1.243) -} -Done diff --git a/ext/oci8/tests/array_bind_int.phpt b/ext/oci8/tests/array_bind_int.phpt deleted file mode 100644 index 3c8bfd4f57..0000000000 --- a/ext/oci8/tests/array_bind_int.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_INT ---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 NUMBER)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF NUMBER 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(1,2,3,4,5); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 5, SQLT_NUM); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - int(5) - [1]=> - int(4) - [2]=> - int(3) - [3]=> - int(2) - [4]=> - int(1) -} -Done diff --git a/ext/oci8/tests/array_bind_int1.phpt b/ext/oci8/tests/array_bind_int1.phpt deleted file mode 100644 index eb2072adcf..0000000000 --- a/ext/oci8/tests/array_bind_int1.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_INT ---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 NUMBER)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF NUMBER 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(1,2,3,4,5); - -oci_bind_array_by_name($statement, ":c1", $array, 10, 5, SQLT_NUM); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - int(5) - [1]=> - int(4) - [2]=> - int(3) - [3]=> - int(2) - [4]=> - int(1) -} -Done diff --git a/ext/oci8/tests/array_bind_str.phpt b/ext/oci8/tests/array_bind_str.phpt deleted file mode 100644 index c8e1e0cdb5..0000000000 --- a/ext/oci8/tests/array_bind_str.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_AVC ---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 VARCHAR(20))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF VARCHAR(20) 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("one", "two", "three", "four", "five"); - -oci_bind_array_by_name($statement, ":c1", $array, 5, 20, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - string(4) "five" - [1]=> - string(4) "four" - [2]=> - string(5) "three" - [3]=> - string(3) "two" - [4]=> - string(3) "one" -} -Done diff --git a/ext/oci8/tests/array_bind_str1.phpt b/ext/oci8/tests/array_bind_str1.phpt deleted file mode 100644 index af4dbfe220..0000000000 --- a/ext/oci8/tests/array_bind_str1.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_bind_array_by_name() and SQLT_AVC ---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 VARCHAR(20))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$create_pkg = " -CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS - TYPE ARRTYPE IS TABLE OF VARCHAR(20) 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("one", "two", "three", "four", "five"); - -oci_bind_array_by_name($statement, ":c1", $array, 10, 20, SQLT_CHR); - -oci_execute($statement); - -var_dump($array); - -echo "Done\n"; -?> ---EXPECT-- -array(5) { - [0]=> - string(4) "five" - [1]=> - string(4) "four" - [2]=> - string(5) "three" - [3]=> - string(3) "two" - [4]=> - string(3) "one" -} -Done diff --git a/ext/oci8/tests/bind_empty.phpt b/ext/oci8/tests/bind_empty.phpt deleted file mode 100644 index 9c602b32c3..0000000000 --- a/ext/oci8/tests/bind_empty.phpt +++ /dev/null @@ -1,39 +0,0 @@ ---TEST-- -binding empty values ---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 VARCHAR(10))"; -$statement = oci_parse($c, $create); -oci_execute($statement); - - -$name = null; -$stmt = oci_parse($c, "UPDATE bind_test SET name=:name"); -oci_bind_by_name($stmt, ":name", $name); - -$res = oci_execute($stmt); - -$name = ""; -$stmt = oci_parse($c, "UPDATE bind_test SET name=:name"); -oci_bind_by_name($stmt, ":name", $name); - -$res = oci_execute($stmt); - -$drop = "DROP table bind_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -echo "Done\n"; - -?> ---EXPECTF-- -Done diff --git a/ext/oci8/tests/bind_long.phpt b/ext/oci8/tests/bind_long.phpt deleted file mode 100644 index ddbc11eb69..0000000000 --- a/ext/oci8/tests/bind_long.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -bind LONG field ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$stmt = oci_parse($c, "create table phptestlng( id number(10), filetxt long)"); -oci_execute($stmt); - -$stmt = oci_parse ($c, "insert into phptestlng (id, filetxt) values (:id, :filetxt)"); -$i=1; -$filetxt = file_get_contents( dirname(__FILE__)."/test.txt"); - -oci_bind_by_name( $stmt, ":id", $i, -1); -oci_bind_by_name( $stmt, ":filetxt", $filetxt, -1, SQLT_LNG); -oci_execute($stmt, OCI_DEFAULT); -oci_commit($c); - -$stmt = oci_parse($c, "SELECT filetxt FROM phptestlng"); -oci_execute($stmt); - -$row = oci_fetch_row($stmt); -var_dump(md5($row[0])); -var_dump(strlen($row[0])); - -$stmt = oci_parse($c, "drop table phptestlng"); -oci_execute($stmt); - -echo "Done\n"; - -?> ---EXPECT-- -string(32) "da852396d08c9ef9fbdf914db1d6d5bb" -int(276) -Done diff --git a/ext/oci8/tests/bind_long_raw.phpt b/ext/oci8/tests/bind_long_raw.phpt deleted file mode 100644 index 2a9962eace..0000000000 --- a/ext/oci8/tests/bind_long_raw.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -bind LONG RAW field ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); -oci_execute($stmt); - -$stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); -$i=1; -$fileimage = file_get_contents( dirname(__FILE__)."/test.gif"); - -oci_bind_by_name( $stmt, ":id", $i, -1); -oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI); -oci_execute($stmt, OCI_DEFAULT); -oci_commit($c); - -$stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); -oci_execute($stmt); - -$row = oci_fetch_row($stmt); -var_dump(md5($row[0])); -var_dump(strlen($row[0])); - -$stmt = oci_parse($c, "drop table phptestlngraw"); -oci_execute($stmt); - -echo "Done\n"; - -?> ---EXPECT-- -string(32) "614fcbba1effb7caa27ef0ef25c27fcf" -int(2523) -Done diff --git a/ext/oci8/tests/bind_raw.phpt b/ext/oci8/tests/bind_raw.phpt deleted file mode 100644 index c9087e552b..0000000000 --- a/ext/oci8/tests/bind_raw.phpt +++ /dev/null @@ -1,39 +0,0 @@ ---TEST-- -bind RAW field ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); -oci_execute($stmt); - -$stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); -$i=1; -$fileimage = file_get_contents( dirname(__FILE__)."/test.gif"); -$fileimage = substr($fileimage, 0, 300); - -oci_bind_by_name( $stmt, ":id", $i, -1); -oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN); -oci_execute($stmt, OCI_DEFAULT); -oci_commit($c); - -$stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); -oci_execute($stmt); - -$row = oci_fetch_row($stmt); -var_dump(md5($row[0])); -var_dump(strlen($row[0])); - -$stmt = oci_parse($c, "drop table phptestrawtable"); -oci_execute($stmt); - -echo "Done\n"; - -?> ---EXPECT-- -string(32) "88b274d7a257ac6f70435b83abd4e26e" -int(300) -Done diff --git a/ext/oci8/tests/bug26133.phpt b/ext/oci8/tests/bug26133.phpt deleted file mode 100644 index df319feb05..0000000000 --- a/ext/oci8/tests/bug26133.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -Bug #26133 (ocifreedesc() segfault) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - - require dirname(__FILE__).'/connect.inc'; - require dirname(__FILE__).'/create_table.inc'; - - if ($c) { - $ora_sql = "INSERT INTO - ".$schema.$table_name." (id, value) - VALUES ('1','1') - RETURNING - ROWID - INTO :v_rowid "; - - $statement = OCIParse($c,$ora_sql); - $rowid = OCINewDescriptor($c,OCI_D_ROWID); - OCIBindByName($statement,":v_rowid", $rowid,-1,OCI_B_ROWID); - if (OCIExecute($statement)) { - OCICommit($c); - } - OCIFreeStatement($statement); - $rowid->free(); - } - - require dirname(__FILE__).'/drop_table.inc'; - - echo "Done\n"; -?> ---EXPECT-- -Done diff --git a/ext/oci8/tests/bug27303.phpt b/ext/oci8/tests/bug27303.phpt deleted file mode 100644 index 191cdffe67..0000000000 --- a/ext/oci8/tests/bug27303.phpt +++ /dev/null @@ -1,252 +0,0 @@ ---TEST-- -bug #27303 (OCIBindByName binds numeric PHP values as characters) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$create_st = array(); -$create_st[] = "drop sequence myseq"; -$create_st[] = "drop table mytab"; -$create_st[] = "create sequence myseq"; -$create_st[] = "create table mytab (mydata varchar2(20), seqcol number)"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -define('MYLIMIT', 200); -define('INITMYBV', 11); - -$stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol into :mybv"; - -$stid = OCIParse($c, $stmt); -if (!$stid) { echo "Parse error"; die; } - -//$mybv = INITMYBV; // Uncomment this for the 2nd test only -$r = OCIBindByName($stid, ':MYBV', $mybv /*, 5 */); // Uncomment this for the 3rd test only -if (!$r) { echo "Bind error"; die; } - -for ($i = 1; $i < MYLIMIT; $i++) { - $r = OCIExecute($stid, OCI_DEFAULT); - if (!$r) { echo "Execute error"; die; } - var_dump($mybv); -} - -OCICommit($c); - -$drop_st = array(); -$drop_st[] = "drop sequence myseq"; -$drop_st[] = "drop table mytab"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -echo "Done\n"; -?> ---EXPECTF-- -string(1) "1" -string(1) "2" -string(1) "3" -string(1) "4" -string(1) "5" -string(1) "6" -string(1) "7" -string(1) "8" -string(1) "9" -string(2) "10" -string(2) "11" -string(2) "12" -string(2) "13" -string(2) "14" -string(2) "15" -string(2) "16" -string(2) "17" -string(2) "18" -string(2) "19" -string(2) "20" -string(2) "21" -string(2) "22" -string(2) "23" -string(2) "24" -string(2) "25" -string(2) "26" -string(2) "27" -string(2) "28" -string(2) "29" -string(2) "30" -string(2) "31" -string(2) "32" -string(2) "33" -string(2) "34" -string(2) "35" -string(2) "36" -string(2) "37" -string(2) "38" -string(2) "39" -string(2) "40" -string(2) "41" -string(2) "42" -string(2) "43" -string(2) "44" -string(2) "45" -string(2) "46" -string(2) "47" -string(2) "48" -string(2) "49" -string(2) "50" -string(2) "51" -string(2) "52" -string(2) "53" -string(2) "54" -string(2) "55" -string(2) "56" -string(2) "57" -string(2) "58" -string(2) "59" -string(2) "60" -string(2) "61" -string(2) "62" -string(2) "63" -string(2) "64" -string(2) "65" -string(2) "66" -string(2) "67" -string(2) "68" -string(2) "69" -string(2) "70" -string(2) "71" -string(2) "72" -string(2) "73" -string(2) "74" -string(2) "75" -string(2) "76" -string(2) "77" -string(2) "78" -string(2) "79" -string(2) "80" -string(2) "81" -string(2) "82" -string(2) "83" -string(2) "84" -string(2) "85" -string(2) "86" -string(2) "87" -string(2) "88" -string(2) "89" -string(2) "90" -string(2) "91" -string(2) "92" -string(2) "93" -string(2) "94" -string(2) "95" -string(2) "96" -string(2) "97" -string(2) "98" -string(2) "99" -string(3) "100" -string(3) "101" -string(3) "102" -string(3) "103" -string(3) "104" -string(3) "105" -string(3) "106" -string(3) "107" -string(3) "108" -string(3) "109" -string(3) "110" -string(3) "111" -string(3) "112" -string(3) "113" -string(3) "114" -string(3) "115" -string(3) "116" -string(3) "117" -string(3) "118" -string(3) "119" -string(3) "120" -string(3) "121" -string(3) "122" -string(3) "123" -string(3) "124" -string(3) "125" -string(3) "126" -string(3) "127" -string(3) "128" -string(3) "129" -string(3) "130" -string(3) "131" -string(3) "132" -string(3) "133" -string(3) "134" -string(3) "135" -string(3) "136" -string(3) "137" -string(3) "138" -string(3) "139" -string(3) "140" -string(3) "141" -string(3) "142" -string(3) "143" -string(3) "144" -string(3) "145" -string(3) "146" -string(3) "147" -string(3) "148" -string(3) "149" -string(3) "150" -string(3) "151" -string(3) "152" -string(3) "153" -string(3) "154" -string(3) "155" -string(3) "156" -string(3) "157" -string(3) "158" -string(3) "159" -string(3) "160" -string(3) "161" -string(3) "162" -string(3) "163" -string(3) "164" -string(3) "165" -string(3) "166" -string(3) "167" -string(3) "168" -string(3) "169" -string(3) "170" -string(3) "171" -string(3) "172" -string(3) "173" -string(3) "174" -string(3) "175" -string(3) "176" -string(3) "177" -string(3) "178" -string(3) "179" -string(3) "180" -string(3) "181" -string(3) "182" -string(3) "183" -string(3) "184" -string(3) "185" -string(3) "186" -string(3) "187" -string(3) "188" -string(3) "189" -string(3) "190" -string(3) "191" -string(3) "192" -string(3) "193" -string(3) "194" -string(3) "195" -string(3) "196" -string(3) "197" -string(3) "198" -string(3) "199" -Done diff --git a/ext/oci8/tests/bug27303_2.phpt b/ext/oci8/tests/bug27303_2.phpt deleted file mode 100644 index 67f3552f13..0000000000 --- a/ext/oci8/tests/bug27303_2.phpt +++ /dev/null @@ -1,252 +0,0 @@ ---TEST-- -bug #27303 (OCIBindByName binds numeric PHP values as characters) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$create_st = array(); -$create_st[] = "drop sequence myseq"; -$create_st[] = "drop table mytab"; -$create_st[] = "create sequence myseq"; -$create_st[] = "create table mytab (mydata varchar2(20), seqcol number)"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -define('MYLIMIT', 200); -define('INITMYBV', 11); - -$stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol into :mybv"; - -$stid = OCIParse($c, $stmt); -if (!$stid) { echo "Parse error"; die; } - -$mybv = INITMYBV; // Uncomment this for the 2nd test only -$r = OCIBindByName($stid, ':MYBV', $mybv /*, 5 */); // Uncomment this for the 3rd test only -if (!$r) { echo "Bind error"; die; } - -for ($i = 1; $i < MYLIMIT; $i++) { - $r = OCIExecute($stid, OCI_DEFAULT); - if (!$r) { echo "Execute error"; die; } - var_dump($mybv); -} - -OCICommit($c); - -$drop_st = array(); -$drop_st[] = "drop sequence myseq"; -$drop_st[] = "drop table mytab"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -echo "Done\n"; -?> ---EXPECTF-- -string(1) "1" -string(1) "2" -string(1) "3" -string(1) "4" -string(1) "5" -string(1) "6" -string(1) "7" -string(1) "8" -string(1) "9" -string(2) "10" -string(2) "11" -string(2) "12" -string(2) "13" -string(2) "14" -string(2) "15" -string(2) "16" -string(2) "17" -string(2) "18" -string(2) "19" -string(2) "20" -string(2) "21" -string(2) "22" -string(2) "23" -string(2) "24" -string(2) "25" -string(2) "26" -string(2) "27" -string(2) "28" -string(2) "29" -string(2) "30" -string(2) "31" -string(2) "32" -string(2) "33" -string(2) "34" -string(2) "35" -string(2) "36" -string(2) "37" -string(2) "38" -string(2) "39" -string(2) "40" -string(2) "41" -string(2) "42" -string(2) "43" -string(2) "44" -string(2) "45" -string(2) "46" -string(2) "47" -string(2) "48" -string(2) "49" -string(2) "50" -string(2) "51" -string(2) "52" -string(2) "53" -string(2) "54" -string(2) "55" -string(2) "56" -string(2) "57" -string(2) "58" -string(2) "59" -string(2) "60" -string(2) "61" -string(2) "62" -string(2) "63" -string(2) "64" -string(2) "65" -string(2) "66" -string(2) "67" -string(2) "68" -string(2) "69" -string(2) "70" -string(2) "71" -string(2) "72" -string(2) "73" -string(2) "74" -string(2) "75" -string(2) "76" -string(2) "77" -string(2) "78" -string(2) "79" -string(2) "80" -string(2) "81" -string(2) "82" -string(2) "83" -string(2) "84" -string(2) "85" -string(2) "86" -string(2) "87" -string(2) "88" -string(2) "89" -string(2) "90" -string(2) "91" -string(2) "92" -string(2) "93" -string(2) "94" -string(2) "95" -string(2) "96" -string(2) "97" -string(2) "98" -string(2) "99" -string(3) "100" -string(3) "101" -string(3) "102" -string(3) "103" -string(3) "104" -string(3) "105" -string(3) "106" -string(3) "107" -string(3) "108" -string(3) "109" -string(3) "110" -string(3) "111" -string(3) "112" -string(3) "113" -string(3) "114" -string(3) "115" -string(3) "116" -string(3) "117" -string(3) "118" -string(3) "119" -string(3) "120" -string(3) "121" -string(3) "122" -string(3) "123" -string(3) "124" -string(3) "125" -string(3) "126" -string(3) "127" -string(3) "128" -string(3) "129" -string(3) "130" -string(3) "131" -string(3) "132" -string(3) "133" -string(3) "134" -string(3) "135" -string(3) "136" -string(3) "137" -string(3) "138" -string(3) "139" -string(3) "140" -string(3) "141" -string(3) "142" -string(3) "143" -string(3) "144" -string(3) "145" -string(3) "146" -string(3) "147" -string(3) "148" -string(3) "149" -string(3) "150" -string(3) "151" -string(3) "152" -string(3) "153" -string(3) "154" -string(3) "155" -string(3) "156" -string(3) "157" -string(3) "158" -string(3) "159" -string(3) "160" -string(3) "161" -string(3) "162" -string(3) "163" -string(3) "164" -string(3) "165" -string(3) "166" -string(3) "167" -string(3) "168" -string(3) "169" -string(3) "170" -string(3) "171" -string(3) "172" -string(3) "173" -string(3) "174" -string(3) "175" -string(3) "176" -string(3) "177" -string(3) "178" -string(3) "179" -string(3) "180" -string(3) "181" -string(3) "182" -string(3) "183" -string(3) "184" -string(3) "185" -string(3) "186" -string(3) "187" -string(3) "188" -string(3) "189" -string(3) "190" -string(3) "191" -string(3) "192" -string(3) "193" -string(3) "194" -string(3) "195" -string(3) "196" -string(3) "197" -string(3) "198" -string(3) "199" -Done diff --git a/ext/oci8/tests/bug27303_3.phpt b/ext/oci8/tests/bug27303_3.phpt deleted file mode 100644 index 3a8982d305..0000000000 --- a/ext/oci8/tests/bug27303_3.phpt +++ /dev/null @@ -1,252 +0,0 @@ ---TEST-- -bug #27303 (OCIBindByName binds numeric PHP values as characters) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$create_st = array(); -$create_st[] = "drop sequence myseq"; -$create_st[] = "drop table mytab"; -$create_st[] = "create sequence myseq"; -$create_st[] = "create table mytab (mydata varchar2(20), seqcol number)"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -define('MYLIMIT', 200); -define('INITMYBV', 11); - -$stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol into :mybv"; - -$stid = OCIParse($c, $stmt); -if (!$stid) { echo "Parse error"; die; } - -$mybv = INITMYBV; // Uncomment this for the 2nd test only -$r = OCIBindByName($stid, ':MYBV', $mybv, 5, SQLT_INT); // Uncomment this for the 3rd test only -if (!$r) { echo "Bind error"; die; } - -for ($i = 1; $i < MYLIMIT; $i++) { - $r = OCIExecute($stid, OCI_DEFAULT); - if (!$r) { echo "Execute error"; die; } - var_dump($mybv); -} - -OCICommit($c); - -$drop_st = array(); -$drop_st[] = "drop sequence myseq"; -$drop_st[] = "drop table mytab"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -echo "Done\n"; -?> ---EXPECTF-- -int(1) -int(2) -int(3) -int(4) -int(5) -int(6) -int(7) -int(8) -int(9) -int(10) -int(11) -int(12) -int(13) -int(14) -int(15) -int(16) -int(17) -int(18) -int(19) -int(20) -int(21) -int(22) -int(23) -int(24) -int(25) -int(26) -int(27) -int(28) -int(29) -int(30) -int(31) -int(32) -int(33) -int(34) -int(35) -int(36) -int(37) -int(38) -int(39) -int(40) -int(41) -int(42) -int(43) -int(44) -int(45) -int(46) -int(47) -int(48) -int(49) -int(50) -int(51) -int(52) -int(53) -int(54) -int(55) -int(56) -int(57) -int(58) -int(59) -int(60) -int(61) -int(62) -int(63) -int(64) -int(65) -int(66) -int(67) -int(68) -int(69) -int(70) -int(71) -int(72) -int(73) -int(74) -int(75) -int(76) -int(77) -int(78) -int(79) -int(80) -int(81) -int(82) -int(83) -int(84) -int(85) -int(86) -int(87) -int(88) -int(89) -int(90) -int(91) -int(92) -int(93) -int(94) -int(95) -int(96) -int(97) -int(98) -int(99) -int(100) -int(101) -int(102) -int(103) -int(104) -int(105) -int(106) -int(107) -int(108) -int(109) -int(110) -int(111) -int(112) -int(113) -int(114) -int(115) -int(116) -int(117) -int(118) -int(119) -int(120) -int(121) -int(122) -int(123) -int(124) -int(125) -int(126) -int(127) -int(128) -int(129) -int(130) -int(131) -int(132) -int(133) -int(134) -int(135) -int(136) -int(137) -int(138) -int(139) -int(140) -int(141) -int(142) -int(143) -int(144) -int(145) -int(146) -int(147) -int(148) -int(149) -int(150) -int(151) -int(152) -int(153) -int(154) -int(155) -int(156) -int(157) -int(158) -int(159) -int(160) -int(161) -int(162) -int(163) -int(164) -int(165) -int(166) -int(167) -int(168) -int(169) -int(170) -int(171) -int(172) -int(173) -int(174) -int(175) -int(176) -int(177) -int(178) -int(179) -int(180) -int(181) -int(182) -int(183) -int(184) -int(185) -int(186) -int(187) -int(188) -int(189) -int(190) -int(191) -int(192) -int(193) -int(194) -int(195) -int(196) -int(197) -int(198) -int(199) -Done diff --git a/ext/oci8/tests/bug27303_4.phpt b/ext/oci8/tests/bug27303_4.phpt deleted file mode 100644 index 8ba4ef44b4..0000000000 --- a/ext/oci8/tests/bug27303_4.phpt +++ /dev/null @@ -1,252 +0,0 @@ ---TEST-- -bug #27303 (OCIBindByName binds numeric PHP values as characters) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$create_st = array(); -$create_st[] = "drop sequence myseq"; -$create_st[] = "drop table mytab"; -$create_st[] = "create sequence myseq"; -$create_st[] = "create table mytab (mydata varchar2(20), seqcol number)"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -define('MYLIMIT', 200); -define('INITMYBV', 11); - -$stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol into :mybv"; - -$stid = OCIParse($c, $stmt); -if (!$stid) { echo "Parse error"; die; } - -//$mybv = INITMYBV; // Uncomment this for the 2nd test only -$r = OCIBindByName($stid, ':MYBV', $mybv, 0 ); // Uncomment this for the 3rd test only -if (!$r) { echo "Bind error"; die; } - -for ($i = 1; $i < MYLIMIT; $i++) { - $r = OCIExecute($stid, OCI_DEFAULT); - if (!$r) { echo "Execute error"; die; } - var_dump($mybv); -} - -OCICommit($c); - -$drop_st = array(); -$drop_st[] = "drop sequence myseq"; -$drop_st[] = "drop table mytab"; - -foreach ($create_st as $statement) { - $stmt = oci_parse($c, $statement); - oci_execute($stmt); -} - -echo "Done\n"; -?> ---EXPECTF-- -string(1) "1" -string(1) "2" -string(1) "3" -string(1) "4" -string(1) "5" -string(1) "6" -string(1) "7" -string(1) "8" -string(1) "9" -string(2) "10" -string(2) "11" -string(2) "12" -string(2) "13" -string(2) "14" -string(2) "15" -string(2) "16" -string(2) "17" -string(2) "18" -string(2) "19" -string(2) "20" -string(2) "21" -string(2) "22" -string(2) "23" -string(2) "24" -string(2) "25" -string(2) "26" -string(2) "27" -string(2) "28" -string(2) "29" -string(2) "30" -string(2) "31" -string(2) "32" -string(2) "33" -string(2) "34" -string(2) "35" -string(2) "36" -string(2) "37" -string(2) "38" -string(2) "39" -string(2) "40" -string(2) "41" -string(2) "42" -string(2) "43" -string(2) "44" -string(2) "45" -string(2) "46" -string(2) "47" -string(2) "48" -string(2) "49" -string(2) "50" -string(2) "51" -string(2) "52" -string(2) "53" -string(2) "54" -string(2) "55" -string(2) "56" -string(2) "57" -string(2) "58" -string(2) "59" -string(2) "60" -string(2) "61" -string(2) "62" -string(2) "63" -string(2) "64" -string(2) "65" -string(2) "66" -string(2) "67" -string(2) "68" -string(2) "69" -string(2) "70" -string(2) "71" -string(2) "72" -string(2) "73" -string(2) "74" -string(2) "75" -string(2) "76" -string(2) "77" -string(2) "78" -string(2) "79" -string(2) "80" -string(2) "81" -string(2) "82" -string(2) "83" -string(2) "84" -string(2) "85" -string(2) "86" -string(2) "87" -string(2) "88" -string(2) "89" -string(2) "90" -string(2) "91" -string(2) "92" -string(2) "93" -string(2) "94" -string(2) "95" -string(2) "96" -string(2) "97" -string(2) "98" -string(2) "99" -string(3) "100" -string(3) "101" -string(3) "102" -string(3) "103" -string(3) "104" -string(3) "105" -string(3) "106" -string(3) "107" -string(3) "108" -string(3) "109" -string(3) "110" -string(3) "111" -string(3) "112" -string(3) "113" -string(3) "114" -string(3) "115" -string(3) "116" -string(3) "117" -string(3) "118" -string(3) "119" -string(3) "120" -string(3) "121" -string(3) "122" -string(3) "123" -string(3) "124" -string(3) "125" -string(3) "126" -string(3) "127" -string(3) "128" -string(3) "129" -string(3) "130" -string(3) "131" -string(3) "132" -string(3) "133" -string(3) "134" -string(3) "135" -string(3) "136" -string(3) "137" -string(3) "138" -string(3) "139" -string(3) "140" -string(3) "141" -string(3) "142" -string(3) "143" -string(3) "144" -string(3) "145" -string(3) "146" -string(3) "147" -string(3) "148" -string(3) "149" -string(3) "150" -string(3) "151" -string(3) "152" -string(3) "153" -string(3) "154" -string(3) "155" -string(3) "156" -string(3) "157" -string(3) "158" -string(3) "159" -string(3) "160" -string(3) "161" -string(3) "162" -string(3) "163" -string(3) "164" -string(3) "165" -string(3) "166" -string(3) "167" -string(3) "168" -string(3) "169" -string(3) "170" -string(3) "171" -string(3) "172" -string(3) "173" -string(3) "174" -string(3) "175" -string(3) "176" -string(3) "177" -string(3) "178" -string(3) "179" -string(3) "180" -string(3) "181" -string(3) "182" -string(3) "183" -string(3) "184" -string(3) "185" -string(3) "186" -string(3) "187" -string(3) "188" -string(3) "189" -string(3) "190" -string(3) "191" -string(3) "192" -string(3) "193" -string(3) "194" -string(3) "195" -string(3) "196" -string(3) "197" -string(3) "198" -string(3) "199" -Done diff --git a/ext/oci8/tests/bug32325.phpt b/ext/oci8/tests/bug32325.phpt deleted file mode 100644 index 6bfcd404eb..0000000000 --- a/ext/oci8/tests/bug32325.phpt +++ /dev/null @@ -1,39 +0,0 @@ ---TEST-- -bug #32325 (Can't retrieve collection using OCI8) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$create_stmt = oci_parse($c, "create or replace type ut_num_list_t as table of number"); -oci_execute($create_stmt); - -$collection = oci_new_collection($c, "UT_NUM_LIST_T"); - -$sql = " - begin - select ut_num_list_t(1,2,3,4) into :list from dual; - end;"; - -$stmt = oci_parse($c, $sql); - -oci_bind_by_name($stmt, ":list", $collection, -1, OCI_B_NTY); -oci_execute($stmt); - -var_dump($collection->size()); -var_dump($collection->getelem(1)); -var_dump($collection->getelem(2)); - -$drop_stmt = oci_parse($c, "drop type ut_num_list_t"); -oci_execute($drop_stmt); - -echo "Done\n"; -?> ---EXPECTF-- -int(4) -float(2) -float(3) -Done diff --git a/ext/oci8/tests/bug35973.phpt b/ext/oci8/tests/bug35973.phpt deleted file mode 100644 index b62f5cfd0f..0000000000 --- a/ext/oci8/tests/bug35973.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -bug #35973 (Error ORA-24806 occurs when trying to fetch a NCLOB field) ---SKIPIF-- -<?php if (!extension_loaded("oci8")) print "skip"; ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$s1 = oci_parse($c, "drop table test_nclob"); -@oci_execute($s1); - -$s2 = oci_parse($c, "create table test_nclob (nc NCLOB)"); -oci_execute($s2); - -$s3 = oci_parse($c, "insert into test_nclob (nc) values ('12345data')"); -oci_execute($s3); - -$s3 = oci_parse($c, "select * from test_nclob"); -oci_execute($s3); - -var_dump($data = oci_fetch_assoc($s3)); -$d = $data['NC']; - -var_dump($d->read(5)); -var_dump($d->read(4)); - -$s1 = oci_parse($c, "drop table test_nclob"); -@oci_execute($s1); - -echo "Done\n"; -?> ---EXPECTF-- -array(1) { - ["NC"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(%d) "%s5" -string(%d) "%sa" -Done diff --git a/ext/oci8/tests/bug36010.phpt b/ext/oci8/tests/bug36010.phpt deleted file mode 100644 index ef435496a8..0000000000 --- a/ext/oci8/tests/bug36010.phpt +++ /dev/null @@ -1,26 +0,0 @@ ---TEST-- -bug #36010 (Crash when executing SQL statment with lob parameter twice) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -function f($conn) -{ - $sql = "begin :p_clob := 'lob string'; end;"; - $stid = oci_parse($conn, $sql); - $clob = oci_new_descriptor($conn, OCI_D_LOB); - oci_bind_by_name($stid, ":p_clob", $clob, -1, OCI_B_CLOB); - $r = oci_execute($stid, OCI_DEFAULT); -} - -f($c); -f($c); - -echo "Done\n"; - -?> ---EXPECT-- -Done diff --git a/ext/oci8/tests/bug36096.phpt b/ext/oci8/tests/bug36096.phpt deleted file mode 100644 index 44b3a6ddca..0000000000 --- a/ext/oci8/tests/bug36096.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -Bug #36096 (oci_result() returns garbage after oci_fetch() failed) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$sql = "SELECT 'ABC' FROM DUAL WHERE 1<>1"; -$stmt = oci_parse($c, $sql); - -if(oci_execute($stmt, OCI_COMMIT_ON_SUCCESS)){ - var_dump(oci_fetch($stmt)); - var_dump(oci_result($stmt, 1)); - var_dump(oci_field_name($stmt, 1)); - var_dump(oci_field_type($stmt, 1)); -} - -echo "Done\n"; - -?> ---EXPECT-- -bool(false) -bool(false) -string(5) "'ABC'" -string(4) "CHAR" -Done diff --git a/ext/oci8/tests/bug37581.phpt b/ext/oci8/tests/bug37581.phpt deleted file mode 100644 index ec86c51959..0000000000 --- a/ext/oci8/tests/bug37581.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -Bug #37581 (oci_bind_array_by_name clobbers input array when using SQLT_AFC, AVC) ---SKIPIF-- -<?php if (!extension_loaded("oci8")) print "skip"; ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$p1 = "create or replace package ARRAYBINDPKG1 as -type str_array is table of char(2) index by binary_integer; -procedure array_bind(in_str in str_array, out_str out string); -end ARRAYBINDPKG1;"; - -$p2 = "create or replace package body ARRAYBINDPKG1 as - procedure array_bind(in_str in str_array, out_str out string) is - begin - for i in 1 .. in_str.count loop - out_str := in_str(i); - end loop; - end array_bind; -end ARRAYBINDPKG1;"; - -$s1 = oci_parse($c, $p1); -$s2 = oci_parse($c, $p2); -oci_execute($s1); -oci_execute($s2); - - -$stmt = oci_parse($c,'begin ARRAYBINDPKG1.array_bind(:in_arr, :out_str); end;'); -$strings = array('A','B','C','D','E'); - -oci_bind_array_by_name($stmt,':in_arr',$strings,5,1,SQLT_AFC); -oci_bind_by_name($stmt,':out_str',$result,10); - -oci_execute($stmt); -var_dump($strings); - -oci_execute($stmt); -var_dump($strings); - -echo "Done\n"; -?> ---EXPECTF-- -array(5) { - [0]=> - string(1) "A" - [1]=> - string(1) "B" - [2]=> - string(1) "C" - [3]=> - string(1) "D" - [4]=> - string(1) "E" -} -array(5) { - [0]=> - string(1) "A" - [1]=> - string(1) "B" - [2]=> - string(1) "C" - [3]=> - string(1) "D" - [4]=> - string(1) "E" -} -Done diff --git a/ext/oci8/tests/bug38161.phpt b/ext/oci8/tests/bug38161.phpt deleted file mode 100644 index 27cfafdc8f..0000000000 --- a/ext/oci8/tests/bug38161.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -bug #38161 (oci_bind_by_name() returns garbage when Oracle didn't set the variable) ---SKIPIF-- -<?php if (!extension_loaded("oci8")) print "skip"; ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$query = "begin if false then :bv := 1; end if; end;"; -$stid = oci_parse($c, $query); -oci_bind_by_name($stid, ":bv", $bv, 22); -oci_execute($stid, OCI_DEFAULT); - -var_dump($bv); -unset($bv); - -$query = "begin if false then :bv := 1; end if; end;"; -$stid = oci_parse($c, $query); -oci_bind_by_name($stid, ":bv", $bv, 22, SQLT_INT); -oci_execute($stid, OCI_DEFAULT); - -var_dump($bv); - -echo "Done\n"; -?> ---EXPECTF-- -NULL -int(0) -Done diff --git a/ext/oci8/tests/bug38173.phpt b/ext/oci8/tests/bug38173.phpt deleted file mode 100644 index b92df9e39e..0000000000 --- a/ext/oci8/tests/bug38173.phpt +++ /dev/null @@ -1,79 +0,0 @@ ---TEST-- -Bug #38173 (Freeing nested cursors causes OCI8 to segfault) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$create_1 = "CREATE TABLE t1 (id INTEGER)"; -$create_2 = "CREATE TABLE t2 (id INTEGER)"; -$drop_1 = "DROP TABLE t1"; -$drop_2 = "DROP TABLE t2"; - -$s1 = oci_parse($c, $drop_1); -$s2 = oci_parse($c, $drop_2); -@oci_execute($s1); -@oci_execute($s2); - -$s1 = oci_parse($c, $create_1); -$s2 = oci_parse($c, $create_2); -oci_execute($s1); -oci_execute($s2); - -for($i=0; $i < 5; $i++) { - $insert = "INSERT INTO t1 VALUES(".$i.")"; - $s = oci_parse($c, $insert); - oci_execute($s); -} - -for($i=0; $i < 5; $i++) { - $insert = "INSERT INTO t2 VALUES(".$i.")"; - $s = oci_parse($c, $insert); - oci_execute($s); -} - -$query =" -SELECT - t1.*, - CURSOR( SELECT * FROM t2 ) as cursor -FROM - t1 -"; - -$sth = oci_parse($c, $query); -oci_execute($sth); - -// dies on oci_free_statement on 2nd pass through loop -while ( $row = oci_fetch_assoc($sth) ) { - print "Got row!\n"; - var_dump(oci_execute($row['CURSOR'])); - var_dump(oci_free_statement($row['CURSOR'])); -} - -$s1 = oci_parse($c, $drop_1); -$s2 = oci_parse($c, $drop_2); -@oci_execute($s1); -@oci_execute($s2); - -echo "Done\n"; - -?> ---EXPECT-- -Got row! -bool(true) -bool(true) -Got row! -bool(true) -bool(true) -Got row! -bool(true) -bool(true) -Got row! -bool(true) -bool(true) -Got row! -bool(true) -bool(true) -Done diff --git a/ext/oci8/tests/close.phpt b/ext/oci8/tests/close.phpt deleted file mode 100644 index 55bb4ea364..0000000000 --- a/ext/oci8/tests/close.phpt +++ /dev/null @@ -1,17 +0,0 @@ ---TEST-- -connect/close/connect ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -oci_close($c); - -oci_connect($user, $password, $dbase); - -echo "Done\n"; -?> ---EXPECTF-- -Done diff --git a/ext/oci8/tests/coll_001.phpt b/ext/oci8/tests/coll_001.phpt deleted file mode 100644 index 57d3cf1b47..0000000000 --- a/ext/oci8/tests/coll_001.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -oci_new_collection() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump(oci_new_collection($c, $type_name)); -var_dump(oci_new_collection($c, "NONEXISTENT")); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} - -Warning: oci_new_collection(): OCI-22303: type ""."NONEXISTENT" not found in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_002.phpt b/ext/oci8/tests/coll_002.phpt deleted file mode 100644 index 6d30519897..0000000000 --- a/ext/oci8/tests/coll_002.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_new_collection() + free() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump($coll1 = oci_new_collection($c, $type_name)); - -var_dump($coll1->free()); -var_dump($coll1->size()); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} -bool(true) - -Warning: OCI-Collection::size(): %d is not a valid oci8 collection resource in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_002_func.phpt b/ext/oci8/tests/coll_002_func.phpt deleted file mode 100644 index 58e641ee24..0000000000 --- a/ext/oci8/tests/coll_002_func.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_new_collection() + free() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump($coll1 = oci_new_collection($c, $type_name)); - -var_dump(oci_free_collection($coll1)); -var_dump(oci_collection_size($coll1)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} -bool(true) - -Warning: oci_collection_size(): %d is not a valid oci8 collection resource in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_003.phpt b/ext/oci8/tests/coll_003.phpt deleted file mode 100644 index b5236ef6f6..0000000000 --- a/ext/oci8/tests/coll_003.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -collection methods ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = oci_new_collection($c, $type_name); - -var_dump($coll1->size()); -var_dump($coll1->max()); -var_dump($coll1->trim(3)); -var_dump($coll1->append(1)); -var_dump($coll1->getElem(0)); -var_dump($coll1->assignElem(0,2)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -int(0) -int(0) - -Warning: OCI-Collection::trim(): OCI-22167: given trim size [3] must be less than or equal to [0] in %s on line %d -bool(false) -bool(true) -float(1) -bool(true) -Done diff --git a/ext/oci8/tests/coll_003_func.phpt b/ext/oci8/tests/coll_003_func.phpt deleted file mode 100644 index f5c6dc7f38..0000000000 --- a/ext/oci8/tests/coll_003_func.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -collection methods ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = oci_new_collection($c, $type_name); - -var_dump(oci_collection_size($coll1)); -var_dump(oci_collection_max($coll1)); -var_dump(oci_collection_trim($coll1, 3)); -var_dump(oci_collection_append($coll1, 1)); -var_dump(oci_collection_element_get($coll1, 0)); -var_dump(oci_collection_element_assign($coll1, 0, 2)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -int(0) -int(0) - -Warning: oci_collection_trim(): OCI-22167: given trim size [3] must be less than or equal to [0] in %s on line %d -bool(false) -bool(true) -float(1) -bool(true) -Done diff --git a/ext/oci8/tests/coll_004.phpt b/ext/oci8/tests/coll_004.phpt deleted file mode 100644 index eb2ac7e26d..0000000000 --- a/ext/oci8/tests/coll_004.phpt +++ /dev/null @@ -1,29 +0,0 @@ ---TEST-- -oci_collection_assign() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = oci_new_collection($c, $type_name); -$coll2 = oci_new_collection($c, $type_name); - -var_dump($coll1->append(1)); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -float(1) -Done diff --git a/ext/oci8/tests/coll_004_func.phpt b/ext/oci8/tests/coll_004_func.phpt deleted file mode 100644 index 57dff2eb35..0000000000 --- a/ext/oci8/tests/coll_004_func.phpt +++ /dev/null @@ -1,29 +0,0 @@ ---TEST-- -oci_collection_assign() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = oci_new_collection($c, $type_name); -$coll2 = oci_new_collection($c, $type_name); - -var_dump(oci_collection_append($coll1, 1)); - -var_dump(oci_collection_assign($coll2, $coll1)); - -var_dump(oci_collection_element_get($coll2, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -float(1) -Done diff --git a/ext/oci8/tests/coll_005.phpt b/ext/oci8/tests/coll_005.phpt deleted file mode 100644 index 0f40069964..0000000000 --- a/ext/oci8/tests/coll_005.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -ocinewcollection() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump(ocinewcollection($c, $type_name)); -var_dump(ocinewcollection($c, "NONEXISTENT")); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} - -Warning: ocinewcollection(): OCI-22303: type ""."NONEXISTENT" not found in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_006.phpt b/ext/oci8/tests/coll_006.phpt deleted file mode 100644 index cf258cbe34..0000000000 --- a/ext/oci8/tests/coll_006.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -ocinewcollection() + free() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump($coll1 = ocinewcollection($c, $type_name)); - -var_dump($coll1->free()); -var_dump($coll1->size()); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} -bool(true) - -Warning: OCI-Collection::size(): %d is not a valid oci8 collection resource in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_006_func.phpt b/ext/oci8/tests/coll_006_func.phpt deleted file mode 100644 index 56707d6087..0000000000 --- a/ext/oci8/tests/coll_006_func.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -ocinewcollection() + free() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -var_dump($coll1 = ocinewcollection($c, $type_name)); - -var_dump(oci_free_collection($coll1)); -var_dump(oci_collection_size($coll1)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -object(OCI-Collection)#%d (1) { - ["collection"]=> - resource(%d) of type (oci8 collection) -} -bool(true) - -Warning: oci_collection_size(): %d is not a valid oci8 collection resource in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/coll_007.phpt b/ext/oci8/tests/coll_007.phpt deleted file mode 100644 index 31e10c065e..0000000000 --- a/ext/oci8/tests/coll_007.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -collection methods ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->size()); -var_dump($coll1->max()); -var_dump($coll1->trim(3)); -var_dump($coll1->append(1)); -var_dump($coll1->getElem(0)); -var_dump($coll1->assignElem(0,2)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -int(0) -int(0) - -Warning: OCI-Collection::trim(): OCI-22167: given trim size [3] must be less than or equal to [0] in %s on line %d -bool(false) -bool(true) -float(1) -bool(true) -Done diff --git a/ext/oci8/tests/coll_008.phpt b/ext/oci8/tests/coll_008.phpt deleted file mode 100644 index 57d44cc9ab..0000000000 --- a/ext/oci8/tests/coll_008.phpt +++ /dev/null @@ -1,29 +0,0 @@ ---TEST-- -ocicollassign() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_type.inc"; - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump($coll1->append(1)); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -float(1) -Done diff --git a/ext/oci8/tests/coll_009.phpt b/ext/oci8/tests/coll_009.phpt deleted file mode 100644 index 296d6493e2..0000000000 --- a/ext/oci8/tests/coll_009.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -collections and wrong dates ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("2005-07-28")); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -Warning: OCI-Collection::append(): OCI-01861: literal does not match format string in %s on line %d -bool(false) -bool(true) -bool(false) -Done diff --git a/ext/oci8/tests/coll_009_func.phpt b/ext/oci8/tests/coll_009_func.phpt deleted file mode 100644 index 3ed416ce09..0000000000 --- a/ext/oci8/tests/coll_009_func.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -collections and wrong dates ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "2005-07-28")); - -var_dump(oci_collection_assign($coll2, $coll1)); - -var_dump(oci_collection_element_get($coll2, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -Warning: oci_collection_append(): OCI-01861: literal does not match format string in %s on line %d -bool(false) -bool(true) -bool(false) -Done diff --git a/ext/oci8/tests/coll_010.phpt b/ext/oci8/tests/coll_010.phpt deleted file mode 100644 index 6f72dd16c1..0000000000 --- a/ext/oci8/tests/coll_010.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -collections and nulls ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump($coll1->append(null)); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -NULL -Done diff --git a/ext/oci8/tests/coll_010_func.phpt b/ext/oci8/tests/coll_010_func.phpt deleted file mode 100644 index 7b63a276f3..0000000000 --- a/ext/oci8/tests/coll_010_func.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -collections and nulls ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, null)); - -var_dump(oci_collection_assign($coll2, $coll1)); - -var_dump(oci_collection_element_get($coll2, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -NULL -Done diff --git a/ext/oci8/tests/coll_011.phpt b/ext/oci8/tests/coll_011.phpt deleted file mode 100644 index 7d805d3f70..0000000000 --- a/ext/oci8/tests/coll_011.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -collections and strings ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("string")); -var_dump($coll1->append("string")); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -bool(true) -string(6) "string" -Done diff --git a/ext/oci8/tests/coll_011_func.phpt b/ext/oci8/tests/coll_011_func.phpt deleted file mode 100644 index dca640e846..0000000000 --- a/ext/oci8/tests/coll_011_func.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -collections and strings ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "string")); -var_dump(oci_collection_append($coll1, "string")); - -var_dump(oci_collection_assign($coll2, $coll1)); - -var_dump(oci_collection_element_get($coll2, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -bool(true) -string(6) "string" -Done diff --git a/ext/oci8/tests/coll_012.phpt b/ext/oci8/tests/coll_012.phpt deleted file mode 100644 index 543dafd902..0000000000 --- a/ext/oci8/tests/coll_012.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -collections and correct dates ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("28-JUL-05")); - -var_dump($coll2->assign($coll1)); - -var_dump($coll2->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(9) "28-JUL-05" -Done diff --git a/ext/oci8/tests/coll_012_func.phpt b/ext/oci8/tests/coll_012_func.phpt deleted file mode 100644 index fd1019e411..0000000000 --- a/ext/oci8/tests/coll_012_func.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -collections and correct dates ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); -$coll2 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "28-JUL-05")); - -var_dump(oci_collection_assign($coll2, $coll1)); - -var_dump(oci_collection_element_get($coll2, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(9) "28-JUL-05" -Done diff --git a/ext/oci8/tests/coll_013.phpt b/ext/oci8/tests/coll_013.phpt deleted file mode 100644 index 00d88bb9a4..0000000000 --- a/ext/oci8/tests/coll_013.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and correct dates (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("28-JUL-05")); -var_dump($coll1->assignElem(0,"01-JAN-05")); -var_dump($coll1->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(9) "01-JAN-05" -Done diff --git a/ext/oci8/tests/coll_013_func.phpt b/ext/oci8/tests/coll_013_func.phpt deleted file mode 100644 index 0d01bc1744..0000000000 --- a/ext/oci8/tests/coll_013_func.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and correct dates (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "28-JUL-05")); -var_dump(oci_collection_element_assign($coll1, 0, "01-JAN-05")); -var_dump(oci_collection_element_get($coll1, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(9) "01-JAN-05" -Done diff --git a/ext/oci8/tests/coll_014.phpt b/ext/oci8/tests/coll_014.phpt deleted file mode 100644 index 8458525ae5..0000000000 --- a/ext/oci8/tests/coll_014.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and strings (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("striing")); -var_dump($coll1->assignElem(0,"blah")); -var_dump($coll1->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(4) "blah" -Done diff --git a/ext/oci8/tests/coll_014_func.phpt b/ext/oci8/tests/coll_014_func.phpt deleted file mode 100644 index a0fe555b61..0000000000 --- a/ext/oci8/tests/coll_014_func.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and strings (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "striing")); -var_dump(oci_collection_element_assign($coll1, 0,"blah")); -var_dump(oci_collection_element_get($coll1, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(4) "blah" -Done diff --git a/ext/oci8/tests/coll_015.phpt b/ext/oci8/tests/coll_015.phpt deleted file mode 100644 index 64b0aea106..0000000000 --- a/ext/oci8/tests/coll_015.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and numbers (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->append(1)); -var_dump($coll1->assignElem(0,2345)); -var_dump($coll1->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -float(2345) -Done diff --git a/ext/oci8/tests/coll_015_func.phpt b/ext/oci8/tests/coll_015_func.phpt deleted file mode 100644 index eeed7839a7..0000000000 --- a/ext/oci8/tests/coll_015_func.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and numbers (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, 1)); -var_dump(oci_collection_element_assign($coll1,0,2345)); -var_dump(oci_collection_element_get($coll1, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -float(2345) -Done diff --git a/ext/oci8/tests/coll_016.phpt b/ext/oci8/tests/coll_016.phpt deleted file mode 100644 index c2af9cc22d..0000000000 --- a/ext/oci8/tests/coll_016.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -collections and negative/too big element indexes ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->append(1)); -var_dump($coll1->assignElem(-1,2345)); -var_dump($coll1->assignElem(5000,2345)); -var_dump($coll1->getElem(-1)); -var_dump($coll1->getElem(-100)); -var_dump($coll1->getElem(500)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -bool(true) - -Warning: OCI-Collection::assignelem(): OCI-22165: given index [%d] must be in the range of %s to [0] in %s on line %d -bool(false) - -Warning: OCI-Collection::assignelem(): OCI-22165: given index [5000] must be in the range of %s to [0] in %s on line %d -bool(false) -bool(false) -bool(false) -bool(false) -Done diff --git a/ext/oci8/tests/coll_016_func.phpt b/ext/oci8/tests/coll_016_func.phpt deleted file mode 100644 index cde26f22f0..0000000000 --- a/ext/oci8/tests/coll_016_func.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -collections and negative/too big element indexes ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, 1)); -var_dump(oci_collection_element_assign($coll1,-1,2345)); -var_dump(oci_collection_element_assign($coll1,5000,2345)); -var_dump(oci_collection_element_get($coll1, -1)); -var_dump(oci_collection_element_get($coll1, -100)); -var_dump(oci_collection_element_get($coll1, 500)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECTF-- -bool(true) - -Warning: oci_collection_element_assign(): OCI-22165: given index [%d] must be in the range of%s0%sto [0] in %s on line %d -bool(false) - -Warning: oci_collection_element_assign(): OCI-22165: given index [5000] must be in the range of%s0%sto [0] in %s on line %d -bool(false) -bool(false) -bool(false) -bool(false) -Done diff --git a/ext/oci8/tests/coll_017.phpt b/ext/oci8/tests/coll_017.phpt deleted file mode 100644 index 42347ba6f8..0000000000 --- a/ext/oci8/tests/coll_017.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and nulls (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump($coll1->append("string")); -var_dump($coll1->assignElem(0, null)); -var_dump($coll1->getElem(0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -NULL -Done diff --git a/ext/oci8/tests/coll_017_func.phpt b/ext/oci8/tests/coll_017_func.phpt deleted file mode 100644 index 914844ae61..0000000000 --- a/ext/oci8/tests/coll_017_func.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -collections and nulls (2) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$ora_sql = "DROP TYPE - ".$type_name." - "; - -$statement = OCIParse($c,$ora_sql); -@OCIExecute($statement); - -$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; - -$statement = OCIParse($c,$ora_sql); -OCIExecute($statement); - - -$coll1 = ocinewcollection($c, $type_name); - -var_dump(oci_collection_append($coll1, "string")); -var_dump(oci_collection_element_assign($coll1, 0, null)); -var_dump(oci_collection_element_get($coll1, 0)); - -echo "Done\n"; - -require dirname(__FILE__)."/drop_type.inc"; - -?> ---EXPECT-- -bool(true) -bool(true) -NULL -Done diff --git a/ext/oci8/tests/commit.phpt b/ext/oci8/tests/commit.phpt deleted file mode 100644 index 3bef318c85..0000000000 --- a/ext/oci8/tests/commit.phpt +++ /dev/null @@ -1,148 +0,0 @@ ---TEST-- -oci_commit()/oci_rollback() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s, OCI_DEFAULT)) { - die("oci_execute(insert) failed!\n"); - } -} - -var_dump(oci_rollback($c)); - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($select = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -/* oci_fetch_all */ -if (!oci_execute($select)) { - die("oci_execute(select) failed!\n"); -} -var_dump(oci_fetch_all($select, $all)); -var_dump($all); - -/* ocifetchstatement */ -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s, OCI_DEFAULT)) { - die("oci_execute(insert) failed!\n"); - } -} - -var_dump(oci_commit($c)); - -/* oci_fetch_all */ -if (!oci_execute($select)) { - die("oci_execute(select) failed!\n"); -} -var_dump(oci_fetch_all($select, $all)); -var_dump($all); - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -int(0) -array(5) { - ["ID"]=> - array(0) { - } - ["VALUE"]=> - array(0) { - } - ["BLOB"]=> - array(0) { - } - ["CLOB"]=> - array(0) { - } - ["STRING"]=> - array(0) { - } -} -bool(true) -int(4) -array(5) { - ["ID"]=> - array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - [3]=> - string(1) "1" - } - ["VALUE"]=> - array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - [3]=> - string(1) "1" - } - ["BLOB"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } - ["CLOB"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } - ["STRING"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } -} -Done diff --git a/ext/oci8/tests/commit_old.phpt b/ext/oci8/tests/commit_old.phpt deleted file mode 100644 index 196e0650cc..0000000000 --- a/ext/oci8/tests/commit_old.phpt +++ /dev/null @@ -1,146 +0,0 @@ ---TEST-- -ocicommit()/ocirollback() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = ociparse($c, $insert_sql))) { - die("ociparse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!ociexecute($s, OCI_DEFAULT)) { - die("ociexecute(insert) failed!\n"); - } -} - -var_dump(ocirollback($c)); - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($select = ociparse($c, $select_sql))) { - die("ociparse(select) failed!\n"); -} - -if (!oci_execute($select)) { - die("ociexecute(select) failed!\n"); -} -var_dump(ocifetchstatement($select, $all)); -var_dump($all); - -/* ocifetchstatement */ -if (!ociexecute($s)) { - die("ociexecute(select) failed!\n"); -} - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = ociparse($c, $insert_sql))) { - die("ociparse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!ociexecute($s, OCI_DEFAULT)) { - die("ociexecute(insert) failed!\n"); - } -} - -var_dump(ocicommit($c)); - -if (!ociexecute($select)) { - die("ociexecute(select) failed!\n"); -} -var_dump(ocifetchstatement($select, $all)); -var_dump($all); - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -int(0) -array(5) { - ["ID"]=> - array(0) { - } - ["VALUE"]=> - array(0) { - } - ["BLOB"]=> - array(0) { - } - ["CLOB"]=> - array(0) { - } - ["STRING"]=> - array(0) { - } -} -bool(true) -int(4) -array(5) { - ["ID"]=> - array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - [3]=> - string(1) "1" - } - ["VALUE"]=> - array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - [3]=> - string(1) "1" - } - ["BLOB"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } - ["CLOB"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } - ["STRING"]=> - array(4) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - [3]=> - NULL - } -} -Done diff --git a/ext/oci8/tests/connect.inc b/ext/oci8/tests/connect.inc deleted file mode 100644 index 887c8fdaa1..0000000000 --- a/ext/oci8/tests/connect.inc +++ /dev/null @@ -1,37 +0,0 @@ -<?php - -/* - * Please, change user, password and dbase to match your configuration. - * - * */ - -$user = "system"; -$password = "system"; -$dbase = "oracle"; - -/* - * You should have privileges to create tables in this schema - * - * */ -/* -$schema = "system"; -*/ - -$table_name = "tb".substr(str_replace(Array(".", "-"), "_", php_uname("n")), 0, 5); -$type_name = strtoupper("tp".substr(str_replace(Array(".", "-"), "_", php_uname("n")), 0, 5)); - - if (!empty($dbase)) { - $c = ocilogon($user,$password,$dbase); - } - else { - $c = ocilogon($user,$password); - } - - if (!empty($schema)) { - $schema = $schema."."; - } - else { - $schema = ''; - } - -?> diff --git a/ext/oci8/tests/connect.phpt b/ext/oci8/tests/connect.phpt deleted file mode 100644 index 6ce4c533ba..0000000000 --- a/ext/oci8/tests/connect.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -oci_connect() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(oci_connect($user, $password, $dbase)); -} -else { - var_dump(oci_connect($user, $password)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -Done diff --git a/ext/oci8/tests/connect_1.phpt b/ext/oci8/tests/connect_1.phpt deleted file mode 100644 index 647a92ceeb..0000000000 --- a/ext/oci8/tests/connect_1.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -oci_pconnect() & oci_new_connect() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump($c1 = oci_pconnect($user, $password, $dbase)); -} -else { - var_dump($c1 = oci_pconnect($user, $password)); -} - -if (!empty($dbase)) { - var_dump($c2 = oci_new_connect($user, $password, $dbase)); -} -else { - var_dump($c2 = oci_new_connect($user, $password)); -} - -var_dump(oci_close($c1)); -var_dump(ocilogoff($c2)); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 persistent connection) -resource(%d) of type (oci8 connection) -bool(true) -bool(true) -Done diff --git a/ext/oci8/tests/connect_1_old.phpt b/ext/oci8/tests/connect_1_old.phpt deleted file mode 100644 index 8210b82d6c..0000000000 --- a/ext/oci8/tests/connect_1_old.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -ociplogon() & ocinlogon() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump($c1 = ociplogon($user, $password, $dbase)); -} -else { - var_dump($c1 = ociplogon($user, $password)); -} - -if (!empty($dbase)) { - var_dump($c2 = ocinlogon($user, $password, $dbase)); -} -else { - var_dump($c2 = ocinlogon($user, $password)); -} - -var_dump(ocilogoff($c1)); -var_dump(ocilogoff($c2)); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 persistent connection) -resource(%d) of type (oci8 connection) -bool(true) -bool(true) -Done diff --git a/ext/oci8/tests/connect_old.phpt b/ext/oci8/tests/connect_old.phpt deleted file mode 100644 index 55f1734a5a..0000000000 --- a/ext/oci8/tests/connect_old.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -ocilogon() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(ocilogon($user, $password, $dbase)); -} -else { - var_dump(ocilogon($user, $password)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -Done diff --git a/ext/oci8/tests/connect_with_charset_001.phpt b/ext/oci8/tests/connect_with_charset_001.phpt deleted file mode 100644 index 9149747cdb..0000000000 --- a/ext/oci8/tests/connect_with_charset_001.phpt +++ /dev/null @@ -1,37 +0,0 @@ ---TEST-- -oci_connect() with invalid character set ---SKIPIF-- -<?php if (!extension_loaded("oci8")) print "skip"; ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -var_dump($c1 = oci_connect($user, $password, $dbase)); -var_dump($c2 = oci_connect($user, $password, $dbase, "")); -var_dump($c3 = oci_connect($user, $password, $dbase, "blah")); -var_dump($c4 = oci_connect($user, $password, $dbase, "obviously wrong")); - -var_dump($c3 == $c4); - -var_dump($c5 = oci_connect($user, $password, $dbase, "US7ASCII")); -var_dump($c6 = oci_connect($user, $password, $dbase, "UTF8")); - -var_dump($c5 == $c6); - -echo "Done\n"; -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) - -Warning: oci_connect(): Invalid character set name: blah in %s on line %d -resource(%d) of type (oci8 connection) - -Warning: oci_connect(): Invalid character set name: obviously wrong in %s on line %d -resource(%d) of type (oci8 connection) -bool(true) -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -bool(false) -Done diff --git a/ext/oci8/tests/connect_without_oracle_home.phpt b/ext/oci8/tests/connect_without_oracle_home.phpt deleted file mode 100644 index 513d60cefd..0000000000 --- a/ext/oci8/tests/connect_without_oracle_home.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -oci_connect() without ORACLE_HOME set (OCIServerAttach() segfaults) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(oci_connect($user, $password, $dbase)); -} -else { - var_dump(oci_connect($user, $password)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: ocilogon(): _oci_open_server failed, check ORACLE_HOME and NLS_LANG variables: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in %sconnect.inc on line %d - -Warning: oci_connect(): _oci_open_server failed, check ORACLE_HOME and NLS_LANG variables: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in %sconnect_without_oracle_home.php on line %d -bool(false) -Done diff --git a/ext/oci8/tests/connect_without_oracle_home_old.phpt b/ext/oci8/tests/connect_without_oracle_home_old.phpt deleted file mode 100644 index 68b11de155..0000000000 --- a/ext/oci8/tests/connect_without_oracle_home_old.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -ocilogon() without ORACLE_HOME set (OCIServerAttach() segfaults) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(ocilogon($user, $password, $dbase)); -} -else { - var_dump(ocilogon($user, $password)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: ocilogon(): _oci_open_server failed, check ORACLE_HOME and NLS_LANG variables: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in %sconnect.inc on line %d - -Warning: oci_connect(): _oci_open_server failed, check ORACLE_HOME and NLS_LANG variables: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in %sconnect_without_oracle_home.php on line %d -bool(false) -Done diff --git a/ext/oci8/tests/create_table.inc b/ext/oci8/tests/create_table.inc deleted file mode 100644 index d6debf2339..0000000000 --- a/ext/oci8/tests/create_table.inc +++ /dev/null @@ -1,19 +0,0 @@ -<?php - - if ($c) { - $ora_sql = "DROP TABLE - ".$schema.$table_name." - "; - - $statement = OCIParse($c, $ora_sql); - @OCIExecute($statement); - - $ora_sql = "CREATE TABLE - ".$schema.$table_name." (id NUMBER, value NUMBER, blob BLOB, clob CLOB, string VARCHAR(10)) - "; - - $statement = OCIParse($c,$ora_sql); - OCIExecute($statement); - } - -?> diff --git a/ext/oci8/tests/create_type.inc b/ext/oci8/tests/create_type.inc deleted file mode 100644 index e23f7cb903..0000000000 --- a/ext/oci8/tests/create_type.inc +++ /dev/null @@ -1,17 +0,0 @@ -<?php - - if ($c) { - $ora_sql = "DROP TYPE - ".$type_name." - "; - - $statement = OCIParse($c,$ora_sql); - @OCIExecute($statement); - - $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER(11)"; - - $statement = OCIParse($c,$ora_sql); - OCIExecute($statement); - } - -?> diff --git a/ext/oci8/tests/cursor_bind.phpt b/ext/oci8/tests/cursor_bind.phpt deleted file mode 100644 index c2ce15cb38..0000000000 --- a/ext/oci8/tests/cursor_bind.phpt +++ /dev/null @@ -1,99 +0,0 @@ ---TEST-- -bind and fetch cursor from a statement ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$drop_table = "DROP TABLE ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $drop_table))) { - die("oci_parse(drop) failed!\n"); -} - -@oci_execute($s); - -$create_table = "CREATE TABLE ".$schema.$table_name." (id NUMBER, value VARCHAR(20))"; - -if (!($s = oci_parse($c, $create_table))) { - die("oci_parse(create) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(create) failed!\n"); -} - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - - -$sql = " -DECLARE -TYPE curtype IS REF CURSOR; -cursor_var curtype; -BEGIN - OPEN cursor_var FOR SELECT id, value FROM ".$schema.$table_name."; - :curs := cursor_var; -END; -"; - -$stmt = oci_parse($c, $sql); - -$cursor = oci_new_cursor($c); -oci_bind_by_name($stmt, ":curs", $cursor, -1, OCI_B_CURSOR); - -oci_execute($stmt); - -oci_execute($cursor); -var_dump(oci_fetch_row($cursor)); -var_dump(oci_fetch_row($cursor)); -var_dump(oci_fetch_row($cursor)); -var_dump(oci_fetch_row($cursor)); - -echo "Done\n"; - -$drop_table = "DROP TABLE ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $drop_table))) { - die("oci_parse(drop) failed!\n"); -} - -@oci_execute($s); - -?> ---EXPECT-- -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -bool(false) -Done diff --git a/ext/oci8/tests/cursor_bind_err.phpt b/ext/oci8/tests/cursor_bind_err.phpt deleted file mode 100644 index 267c4d94fb..0000000000 --- a/ext/oci8/tests/cursor_bind_err.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -binding a cursor (with errors) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$sql = "select CURSOR(select * from ".$schema.$table_name.") into :cursor from dual"; -$stmt = oci_parse($c, $sql); - -$cursor = oci_new_cursor($c); -oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR); - -oci_execute($stmt); - -oci_execute($cursor); -var_dump(oci_fetch_assoc($cursor)); - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in %s on line %d - -Warning: oci_fetch_assoc(): ORA-24338: statement handle not executed in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/cursors.phpt b/ext/oci8/tests/cursors.phpt deleted file mode 100644 index 22c89c9c54..0000000000 --- a/ext/oci8/tests/cursors.phpt +++ /dev/null @@ -1,65 +0,0 @@ ---TEST-- -fetching cursor from a statement ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$sql = "select CURSOR(select * from ".$schema.$table_name.") as curs FROM dual"; -$stmt = oci_parse($c, $sql); - -oci_execute($stmt); - -while ($data = oci_fetch_assoc($stmt)) { - oci_execute($data["CURS"]); - $subdata = oci_fetch_assoc($data["CURS"]); - var_dump($subdata); - var_dump(oci_cancel($data["CURS"])); - $subdata = oci_fetch_assoc($data["CURS"]); - var_dump($subdata); - var_dump(oci_cancel($data["CURS"])); -} - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECTF-- -array(5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -bool(true) - -Warning: oci_fetch_assoc(): ORA-01002: fetch out of sequence in %s on line %d -bool(false) -bool(true) -Done diff --git a/ext/oci8/tests/cursors_old.phpt b/ext/oci8/tests/cursors_old.phpt deleted file mode 100644 index cf3b5f9575..0000000000 --- a/ext/oci8/tests/cursors_old.phpt +++ /dev/null @@ -1,64 +0,0 @@ ---TEST-- -fetching cursor from a statement ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = ociparse($c, $insert_sql))) { - die("ociparse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!ociexecute($s)) { - die("ociexecute(insert) failed!\n"); - } -} - -if (!ocicommit($c)) { - die("ocicommit() failed!\n"); -} - -$sql = "select CURSOR(select * from ".$schema.$table_name.") as curs FROM dual"; -$stmt = ociparse($c, $sql); - -ociexecute($stmt); - -while ($result = ocifetchinto($stmt, $data, OCI_ASSOC)) { - ociexecute($data["CURS"]); - ocifetchinto($data["CURS"], $subdata, OCI_ASSOC); - var_dump($subdata); - var_dump(ocicancel($data["CURS"])); - ocifetchinto($data["CURS"], $subdata, OCI_ASSOC); - var_dump($subdata); - var_dump(ocicancel($data["CURS"])); -} - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECTF-- -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -bool(true) - -Warning: ocifetchinto():%sORA-01002: fetch out of sequence in %scursors_old.php on line %d -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -bool(true) -Done diff --git a/ext/oci8/tests/debug.phpt b/ext/oci8/tests/debug.phpt deleted file mode 100644 index cc771d5319..0000000000 --- a/ext/oci8/tests/debug.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -oci_internal_debug() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -oci_internal_debug(true); - -if (!empty($dbase)) { - oci_connect($user, $password, $dbase); -} -else { - oci_connect($user, $password); -} - -echo "Done\n"; - -?> ---EXPECTF-- -OCI8 DEBUG: OCINlsEnvironmentVariableGet at (%s:%d) -Done -OCI8 DEBUG: OCISessionEnd at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIServerDetach at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) -OCI8 DEBUG: OCIHandleFree at (%s:%d) diff --git a/ext/oci8/tests/default_prefetch.phpt b/ext/oci8/tests/default_prefetch.phpt deleted file mode 100644 index cc02b6a1c3..0000000000 --- a/ext/oci8/tests/default_prefetch.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -oci8.default_prefetch ini option ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.default_prefetch=20 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(oci_fetch($s)); - -var_dump(oci_num_rows($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -int(1) -Done diff --git a/ext/oci8/tests/default_prefetch1.phpt b/ext/oci8/tests/default_prefetch1.phpt deleted file mode 100644 index aa130e9f93..0000000000 --- a/ext/oci8/tests/default_prefetch1.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -oci8.default_prefetch ini option ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.default_prefetch=100 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(oci_fetch($s)); - -var_dump(oci_num_rows($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -int(1) -Done diff --git a/ext/oci8/tests/default_prefetch2.phpt b/ext/oci8/tests/default_prefetch2.phpt deleted file mode 100644 index ac623a2744..0000000000 --- a/ext/oci8/tests/default_prefetch2.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -oci8.default_prefetch ini option ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.default_prefetch=100 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -var_dump(oci_set_prefetch($s, 10)); - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(oci_fetch($s)); - -var_dump(oci_num_rows($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -bool(true) -int(1) -Done diff --git a/ext/oci8/tests/define.phpt b/ext/oci8/tests/define.phpt deleted file mode 100644 index c76f360f28..0000000000 --- a/ext/oci8/tests/define.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -oci_define_by_name() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (string) VALUES ('some')"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); -} - -$stmt = oci_parse($c, "SELECT string FROM ".$table_name.""); - -/* the define MUST be done BEFORE ociexecute! */ - -$strong = ''; -oci_define_by_name($stmt, "STRING", $string, 20); - -oci_execute($stmt); - -while (oci_fetch($stmt)) { - var_dump($string); -} - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECT-- -string(4) "some" -Done diff --git a/ext/oci8/tests/define1.phpt b/ext/oci8/tests/define1.phpt deleted file mode 100644 index f6e04cc185..0000000000 --- a/ext/oci8/tests/define1.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -oci_define_by_name() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (string) VALUES ('some')"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); -} - -$stmt = oci_parse($c, "SELECT string FROM ".$table_name.""); - -/* the define MUST be done BEFORE ociexecute! */ - -$strong = ''; -var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); -var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); -var_dump(oci_define_by_name($stmt, "", $string, 20)); -var_dump(oci_define_by_name($stmt, "")); - -oci_execute($stmt); - -while (oci_fetch($stmt)) { - var_dump($string); -} - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECTF-- -bool(true) -bool(false) - -Warning: oci_define_by_name(): Column name cannot be empty in %s on line %d -bool(false) - -Warning: oci_define_by_name() expects at least 3 parameters, 2 given in %s on line %d -NULL -string(4) "some" -Done diff --git a/ext/oci8/tests/define_old.phpt b/ext/oci8/tests/define_old.phpt deleted file mode 100644 index da52e619ce..0000000000 --- a/ext/oci8/tests/define_old.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -ocidefinebyname() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__)."/create_table.inc"; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (string) VALUES ('some')"; - -if (!($s = ociparse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -if (!ociexecute($s)) { - die("oci_execute(insert) failed!\n"); -} - -$stmt = ociparse($c, "SELECT string FROM ".$table_name.""); - -/* the define MUST be done BEFORE ociexecute! */ - -$strong = ''; -ocidefinebyname($stmt, "STRING", $string, 20); - -ociexecute($stmt); - -while (ocifetch($stmt)) { - var_dump($string); -} - -require dirname(__FILE__)."/drop_table.inc"; - -echo "Done\n"; - -?> ---EXPECT-- -string(4) "some" -Done diff --git a/ext/oci8/tests/descriptors.phpt b/ext/oci8/tests/descriptors.phpt deleted file mode 100644 index 8be4f3a06d..0000000000 --- a/ext/oci8/tests/descriptors.phpt +++ /dev/null @@ -1,49 +0,0 @@ ---TEST-- -commit connection after destroying the descriptor ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -unset($blob); -unset($statement); - -oci_commit($c); - -$ora_sql = "SELECT blob FROM ".$schema.$table_name." "; -$statement = oci_parse($c,$ora_sql); -oci_execute($statement, OCI_DEFAULT); - -var_dump($row = oci_fetch_assoc($statement)); -unset($row['BLOB']); - -oci_commit($c); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECTF-- -array(1) { - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -Done diff --git a/ext/oci8/tests/drop_table.inc b/ext/oci8/tests/drop_table.inc deleted file mode 100644 index ffd99f5af3..0000000000 --- a/ext/oci8/tests/drop_table.inc +++ /dev/null @@ -1,12 +0,0 @@ -<?php - - if ($c) { - $ora_sql = "DROP TABLE - ".$schema.$table_name." - "; - - $statement = OCIParse($c,$ora_sql); - OCIExecute($statement); - } - -?> diff --git a/ext/oci8/tests/drop_type.inc b/ext/oci8/tests/drop_type.inc deleted file mode 100644 index 047968ef28..0000000000 --- a/ext/oci8/tests/drop_type.inc +++ /dev/null @@ -1,12 +0,0 @@ -<?php - - if ($c) { - $ora_sql = "DROP TYPE - ".$type_name." - "; - - $statement = OCIParse($c,$ora_sql); - OCIExecute($statement); - } - -?> diff --git a/ext/oci8/tests/error.phpt b/ext/oci8/tests/error.phpt deleted file mode 100644 index 743820f901..0000000000 --- a/ext/oci8/tests/error.phpt +++ /dev/null @@ -1,40 +0,0 @@ ---TEST-- -oci_error() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(oci_connect($user, $password, $dbase)); -} -else { - var_dump(oci_connect($user, $password)); -} - -var_dump($s = oci_parse($c, "WRONG SYNTAX")); -var_dump(oci_execute($s)); -var_dump(oci_error($s)); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%s) of type (oci8 connection) -resource(%s) of type (oci8 statement) - -Warning: oci_execute(): ORA-00900: invalid SQL statement in %s on line %d -bool(false) -array(4) { - ["code"]=> - int(900) - ["message"]=> - string(32) "ORA-00900: invalid SQL statement" - ["offset"]=> - int(0) - ["sqltext"]=> - string(12) "WRONG SYNTAX" -} -Done diff --git a/ext/oci8/tests/error1.phpt b/ext/oci8/tests/error1.phpt deleted file mode 100644 index 25a3f09e92..0000000000 --- a/ext/oci8/tests/error1.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -oci_error() when oci_connect() fails ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -var_dump(oci_connect("some", "some", "some")); -var_dump(oci_error()); - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: oci_connect(): ORA-12154: TNS:could not resolve %s in %s on line %d -bool(false) -array(4) { - ["code"]=> - int(12154) - ["message"]=> - string(%d) "ORA-12154: TNS:could not resolve %s" - ["offset"]=> - int(0) - ["sqltext"]=> - string(0) "" -} -Done diff --git a/ext/oci8/tests/error_old.phpt b/ext/oci8/tests/error_old.phpt deleted file mode 100644 index a6889c897a..0000000000 --- a/ext/oci8/tests/error_old.phpt +++ /dev/null @@ -1,40 +0,0 @@ ---TEST-- -ocierror() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump(ocilogon($user, $password, $dbase)); -} -else { - var_dump(ocilogon($user, $password)); -} - -var_dump($s = ociparse($c, "WRONG SYNTAX")); -var_dump(ociexecute($s)); -var_dump(ocierror($s)); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%s) of type (oci8 connection) -resource(%s) of type (oci8 statement) - -Warning: ociexecute(): ORA-00900: invalid SQL statement in %s on line %d -bool(false) -array(4) { - ["code"]=> - int(900) - ["message"]=> - string(32) "ORA-00900: invalid SQL statement" - ["offset"]=> - int(0) - ["sqltext"]=> - string(12) "WRONG SYNTAX" -} -Done diff --git a/ext/oci8/tests/exec_fetch.phpt b/ext/oci8/tests/exec_fetch.phpt deleted file mode 100644 index 83aae69f7d..0000000000 --- a/ext/oci8/tests/exec_fetch.phpt +++ /dev/null @@ -1,24 +0,0 @@ ---TEST-- -fetch after failed oci_execute() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$sql = "select 2 from nonex_dual"; -$stmt = oci_parse($c, $sql); - -var_dump(oci_execute($stmt)); -var_dump(oci_fetch_array($stmt)); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_execute(): ORA-00942: table or view does not exist in %s on line %d -bool(false) - -Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/execute_mode.phpt b/ext/oci8/tests/execute_mode.phpt deleted file mode 100644 index 90570cae80..0000000000 --- a/ext/oci8/tests/execute_mode.phpt +++ /dev/null @@ -1,19 +0,0 @@ ---TEST-- -oci_execute() and invalid execute mode ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$pc = oci_pconnect($user, $password, $dbase); - -$stmt = oci_parse($pc, "select NULL from dual"); -oci_execute($stmt, -1); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_execute(): Invalid execute mode given: -1 in %s on line %d -Done diff --git a/ext/oci8/tests/fetch.phpt b/ext/oci8/tests/fetch.phpt deleted file mode 100644 index 33cba657b6..0000000000 --- a/ext/oci8/tests/fetch.phpt +++ /dev/null @@ -1,56 +0,0 @@ ---TEST-- -ocifetch() & ociresult() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -while(ocifetch($s)) { - $i = 1; - while ($row = ociresult($s, $i)) { - $i++; - var_dump($row); - } -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -string(1) "1" -string(1) "1" -string(1) "1" -string(1) "1" -string(1) "1" -string(1) "1" -Done diff --git a/ext/oci8/tests/fetch_all.phpt b/ext/oci8/tests/fetch_all.phpt deleted file mode 100644 index 5d3738b892..0000000000 --- a/ext/oci8/tests/fetch_all.phpt +++ /dev/null @@ -1,149 +0,0 @@ ---TEST-- -oci_fetch_all() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -/* oci_fetch_all */ -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -var_dump(oci_fetch_all($s, $all)); -var_dump($all); - -/* ocifetchstatement */ -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(ocifetchstatement($s, $all)); -var_dump($all); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -int(3) -array(5) { - ["ID"]=> - array(3) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - } - ["VALUE"]=> - array(3) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - } - ["BLOB"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } - ["CLOB"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } - ["STRING"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } -} -int(3) -array(5) { - ["ID"]=> - array(3) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - } - ["VALUE"]=> - array(3) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - string(1) "1" - } - ["BLOB"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } - ["CLOB"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } - ["STRING"]=> - array(3) { - [0]=> - NULL - [1]=> - NULL - [2]=> - NULL - } -} -Done diff --git a/ext/oci8/tests/fetch_array.phpt b/ext/oci8/tests/fetch_array.phpt deleted file mode 100644 index e2f32483d5..0000000000 --- a/ext/oci8/tests/fetch_array.phpt +++ /dev/null @@ -1,308 +0,0 @@ ---TEST-- -oci_fetch_array() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s)) { - var_dump($row); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s, OCI_NUM)) { - var_dump($row); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s, OCI_ASSOC)) { - var_dump($row); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s, OCI_BOTH)) { - var_dump($row); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s, OCI_RETURN_LOBS)) { - var_dump($row); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_array($s, OCI_RETURN_NULLS)) { - var_dump($row); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -Done diff --git a/ext/oci8/tests/fetch_assoc.phpt b/ext/oci8/tests/fetch_assoc.phpt deleted file mode 100644 index 7dacf2e5b2..0000000000 --- a/ext/oci8/tests/fetch_assoc.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -oci_fetch_assoc() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_assoc($s)) { - var_dump($row); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -array(5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -array(5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -array(5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -Done diff --git a/ext/oci8/tests/fetch_into.phpt b/ext/oci8/tests/fetch_into.phpt deleted file mode 100644 index 379f5fc14e..0000000000 --- a/ext/oci8/tests/fetch_into.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -ocifetchinto() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -/* oci_fetch_all */ -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -var_dump(ocifetchinto($s, $all)); -var_dump($all); - -/* oci_fetch_all */ -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS)); -var_dump($all); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -int(5) -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -int(5) -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -Done diff --git a/ext/oci8/tests/fetch_into1.phpt b/ext/oci8/tests/fetch_into1.phpt deleted file mode 100644 index 263590d140..0000000000 --- a/ext/oci8/tests/fetch_into1.phpt +++ /dev/null @@ -1,192 +0,0 @@ ---TEST-- -various ocifetchinto() tests ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value, string) VALUES (1, 1, NULL)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<20; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -var_dump(ocifetchinto($s, $all, OCI_NUM)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_ASSOC)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_RETURN_NULLS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_RETURN_LOBS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_RETURN_NULLS+OCI_RETURN_LOBS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_RETURN_NULLS+OCI_RETURN_LOBS)); -var_dump($all); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -int(5) -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -int(5) -array(2) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -int(5) -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -int(5) -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -int(5) -array(4) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" -} -int(5) -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -int(5) -array(10) { - [0]=> - string(1) "1" - ["ID"]=> - string(1) "1" - [1]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - [2]=> - NULL - ["BLOB"]=> - NULL - [3]=> - NULL - ["CLOB"]=> - NULL - [4]=> - NULL - ["STRING"]=> - NULL -} -int(5) -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -int(5) -array(5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -int(5) -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -Done diff --git a/ext/oci8/tests/fetch_into2.phpt b/ext/oci8/tests/fetch_into2.phpt deleted file mode 100644 index c196d39f62..0000000000 --- a/ext/oci8/tests/fetch_into2.phpt +++ /dev/null @@ -1,70 +0,0 @@ ---TEST-- -ocifetchinto() & wrong number of params ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value, string) VALUES (1, 1, NULL)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<20; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -var_dump(ocifetchinto($s)); -var_dump($all); -var_dump(ocifetchinto($s, $all, OCI_ASSOC, 5)); -var_dump($all); -var_dump(ocifetchinto($c, $all, OCI_RETURN_LOBS)); -var_dump($all); -var_dump(ocifetchinto($s, $all, 1000000)); -var_dump($all); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECTF-- -Warning: ocifetchinto() expects at least 2 parameters, 1 given in %s on line %d -NULL - -Notice: Undefined variable: all in %s on line %d -NULL - -Warning: ocifetchinto() expects at most 3 parameters, 4 given in %s on line %d -NULL -NULL - -Warning: ocifetchinto(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) -NULL -int(5) -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" -} -Done diff --git a/ext/oci8/tests/fetch_object.phpt b/ext/oci8/tests/fetch_object.phpt deleted file mode 100644 index 57b7fc03d8..0000000000 --- a/ext/oci8/tests/fetch_object.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -oci_fetch_object() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_object($s)) { - var_dump($row); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(stdClass)#%d (5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -object(stdClass)#%d (5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -object(stdClass)#%d (5) { - ["ID"]=> - string(1) "1" - ["VALUE"]=> - string(1) "1" - ["BLOB"]=> - NULL - ["CLOB"]=> - NULL - ["STRING"]=> - NULL -} -Done diff --git a/ext/oci8/tests/fetch_row.phpt b/ext/oci8/tests/fetch_row.phpt deleted file mode 100644 index a637ecc6f4..0000000000 --- a/ext/oci8/tests/fetch_row.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -oci_fetch_row() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} -while ($row = oci_fetch_row($s)) { - var_dump($row); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -Done diff --git a/ext/oci8/tests/field_funcs.phpt b/ext/oci8/tests/field_funcs.phpt deleted file mode 100644 index 102f2fdc03..0000000000 --- a/ext/oci8/tests/field_funcs.phpt +++ /dev/null @@ -1,105 +0,0 @@ ---TEST-- -oci_field_*() family ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -$row = oci_fetch_array($s, OCI_NUM + OCI_RETURN_NULLS + OCI_RETURN_LOBS); -var_dump($row); - -foreach ($row as $num => $field) { - $num++; - var_dump(oci_field_is_null($s, $num)); - var_dump(oci_field_name($s, $num)); - var_dump(oci_field_type($s, $num)); - var_dump(oci_field_type_raw($s, $num)); - var_dump(oci_field_scale($s, $num)); - var_dump(oci_field_precision($s, $num)); - var_dump(oci_field_size($s, $num)); -} - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -bool(false) -string(2) "ID" -string(6) "NUMBER" -int(2) -int(%d) -int(0) -int(22) -bool(false) -string(5) "VALUE" -string(6) "NUMBER" -int(2) -int(%d) -int(0) -int(22) -bool(true) -string(4) "BLOB" -string(4) "BLOB" -int(113) -int(0) -int(0) -int(4000) -bool(true) -string(4) "CLOB" -string(4) "CLOB" -int(112) -int(0) -int(0) -int(4000) -bool(true) -string(6) "STRING" -string(8) "VARCHAR2" -int(1) -int(0) -int(0) -int(10) -Done diff --git a/ext/oci8/tests/field_funcs1.phpt b/ext/oci8/tests/field_funcs1.phpt deleted file mode 100644 index b41e743e41..0000000000 --- a/ext/oci8/tests/field_funcs1.phpt +++ /dev/null @@ -1,179 +0,0 @@ ---TEST-- -oci_field_*() family ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -$row = oci_fetch_array($s, OCI_NUM + OCI_RETURN_NULLS + OCI_RETURN_LOBS); -var_dump($row); - -var_dump(oci_field_is_null($s, -1)); -var_dump(oci_field_name($s, -1)); -var_dump(oci_field_type($s, -1)); -var_dump(oci_field_type_raw($s, -1)); -var_dump(oci_field_scale($s, -1)); -var_dump(oci_field_precision($s, -1)); -var_dump(oci_field_size($s, -1)); - -var_dump(oci_field_is_null($s, "none")); -var_dump(oci_field_name($s, "none")); -var_dump(oci_field_type($s, "none")); -var_dump(oci_field_type_raw($s, "none")); -var_dump(oci_field_scale($s, "none")); -var_dump(oci_field_precision($s, "none")); -var_dump(oci_field_size($s, "none")); - -var_dump(oci_field_is_null($c, -1)); -var_dump(oci_field_name($c, -1)); -var_dump(oci_field_type($c, -1)); -var_dump(oci_field_type_raw($c, -1)); -var_dump(oci_field_scale($c, -1)); -var_dump(oci_field_precision($c, -1)); -var_dump(oci_field_size($c, -1)); - -var_dump(oci_field_is_null($s, array())); -var_dump(oci_field_name($s, array())); -var_dump(oci_field_type($s, array())); -var_dump(oci_field_type_raw($s, array())); -var_dump(oci_field_scale($s, array())); -var_dump(oci_field_precision($s, array())); -var_dump(oci_field_size($s, array())); - -var_dump(oci_field_size($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} - -Warning: oci_field_is_null(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_name(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_type(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_type_raw(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_scale(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_precision(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_size(): Invalid column index "-1" in %s on line %d -bool(false) - -Warning: oci_field_is_null(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_name(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_type(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_type_raw(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_scale(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_precision(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_size(): Invalid column name "none" in %s on line %d -bool(false) - -Warning: oci_field_is_null(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_name(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_type(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_type_raw(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_scale(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_precision(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_size(): supplied resource is not a valid oci8 statement resource in %s on line %d -bool(false) - -Warning: oci_field_is_null(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_name(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_type(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_type_raw(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_scale(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_precision(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_size(): Invalid column index "0" in %s on line %d -bool(false) - -Warning: oci_field_size() expects exactly 2 parameters, 1 given in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/field_funcs_old.phpt b/ext/oci8/tests/field_funcs_old.phpt deleted file mode 100644 index e6f21d613d..0000000000 --- a/ext/oci8/tests/field_funcs_old.phpt +++ /dev/null @@ -1,105 +0,0 @@ ---TEST-- -ocicolumn*() family ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)"; - -if (!($s = ociparse($c, $insert_sql))) { - die("ociparse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!ociexecute($s)) { - die("ociexecute(insert) failed!\n"); - } -} - -if (!ocicommit($c)) { - die("ocicommit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema."".$table_name.""; - -if (!($s = ociparse($c, $select_sql))) { - die("ociparse(select) failed!\n"); -} - -if (!ociexecute($s)) { - die("ociexecute(select) failed!\n"); -} - -ocifetchinto($s, $row, OCI_NUM + OCI_RETURN_NULLS + OCI_RETURN_LOBS); -var_dump($row); - -foreach ($row as $num => $field) { - $num++; - var_dump(ocicolumnisnull($s, $num)); - var_dump(ocicolumnname($s, $num)); - var_dump(ocicolumntype($s, $num)); - var_dump(ocicolumntyperaw($s, $num)); - var_dump(ocicolumnscale($s, $num)); - var_dump(ocicolumnprecision($s, $num)); - var_dump(ocicolumnsize($s, $num)); -} - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -array(5) { - [0]=> - string(1) "1" - [1]=> - string(1) "1" - [2]=> - NULL - [3]=> - NULL - [4]=> - NULL -} -bool(false) -string(2) "ID" -string(6) "NUMBER" -int(2) -int(%d) -int(0) -int(22) -bool(false) -string(5) "VALUE" -string(6) "NUMBER" -int(2) -int(%d) -int(0) -int(22) -bool(true) -string(4) "BLOB" -string(4) "BLOB" -int(113) -int(0) -int(0) -int(4000) -bool(true) -string(4) "CLOB" -string(4) "CLOB" -int(112) -int(0) -int(0) -int(4000) -bool(true) -string(6) "STRING" -string(8) "VARCHAR2" -int(1) -int(0) -int(0) -int(10) -Done diff --git a/ext/oci8/tests/lob_001.phpt b/ext/oci8/tests/lob_001.phpt Binary files differdeleted file mode 100644 index cbcb92e7ec..0000000000 --- a/ext/oci8/tests/lob_001.phpt +++ /dev/null diff --git a/ext/oci8/tests/lob_002.phpt b/ext/oci8/tests/lob_002.phpt deleted file mode 100644 index ebbef1815e..0000000000 --- a/ext/oci8/tests/lob_002.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -oci_lob_write() and friends (with errors) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump($blob->write("test", -1)); -var_dump($blob->write("test", "str")); -var_dump($blob->write("test", 1000000)); -var_dump($blob->write(str_repeat("test", 10000), 1000000)); -var_dump($blob->tell()); -var_dump($blob->seek("str", -5)); -var_dump($blob->flush()); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name.""; -$s = oci_parse($c, $select_sql); -oci_execute($s); - -$row = oci_fetch_array($s, OCI_RETURN_LOBS); - -var_dump(strlen($row[0])); - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(0) - -Warning: OCI-Lob::write() expects parameter 2 to be long, string given in %slob_002.php on line %d -NULL -int(4) -int(40000) -int(40004) - -Warning: OCI-Lob::seek() expects parameter 1 to be long, string given in %slob_002.php on line %d -NULL -bool(false) -int(40004) -Done diff --git a/ext/oci8/tests/lob_003.phpt b/ext/oci8/tests/lob_003.phpt Binary files differdeleted file mode 100644 index 8a492d16ca..0000000000 --- a/ext/oci8/tests/lob_003.phpt +++ /dev/null diff --git a/ext/oci8/tests/lob_004.phpt b/ext/oci8/tests/lob_004.phpt deleted file mode 100644 index 32de4a0120..0000000000 --- a/ext/oci8/tests/lob_004.phpt +++ /dev/null @@ -1,80 +0,0 @@ ---TEST-- -oci_lob_seek()/rewind()/append() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump($blob->write("test")); -var_dump($blob->rewind()); -var_dump($blob->write("str")); -var_dump($blob->seek(10, OCI_SEEK_SET)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump($row[0]->append($blob)); -var_dump($row[0]->read(10000)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -$row = oci_fetch_array($s); - -var_dump($row[0]->read(10000)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(4) -bool(true) -int(3) -bool(true) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -bool(true) -string(4) "strt" -string(8) "strtstrt" -Done diff --git a/ext/oci8/tests/lob_005.phpt b/ext/oci8/tests/lob_005.phpt deleted file mode 100644 index e1ac6e5340..0000000000 --- a/ext/oci8/tests/lob_005.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -oci_lob_is_equal() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump(oci_lob_is_equal($row[0], $row['BLOB'])); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -bool(true) -Done diff --git a/ext/oci8/tests/lob_006.phpt b/ext/oci8/tests/lob_006.phpt Binary files differdeleted file mode 100644 index 3192ebc906..0000000000 --- a/ext/oci8/tests/lob_006.phpt +++ /dev/null diff --git a/ext/oci8/tests/lob_007.phpt b/ext/oci8/tests/lob_007.phpt deleted file mode 100644 index 1fe63092c6..0000000000 --- a/ext/oci8/tests/lob_007.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -oci_lob_write()/size()/load() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump($blob->size()); -var_dump($blob->write(str_repeat("string.", 1000))); -var_dump($blob->size()); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump($row[0]->size()); -var_dump(strlen($row[0]->load())); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(0) -int(7000) -int(7000) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -int(7000) -int(7000) -Done diff --git a/ext/oci8/tests/lob_008.phpt b/ext/oci8/tests/lob_008.phpt deleted file mode 100644 index a36bb4a340..0000000000 --- a/ext/oci8/tests/lob_008.phpt +++ /dev/null @@ -1,65 +0,0 @@ ---TEST-- -oci_lob_write()/read()/eof() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump($blob->write(str_repeat("string.", 1000))); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - - -$len = 0; -while (!$row[0]->eof()) { - $len += strlen($row[0]->read(1024)); -} -var_dump($len); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(7000) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -int(7000) -Done diff --git a/ext/oci8/tests/lob_009.phpt b/ext/oci8/tests/lob_009.phpt deleted file mode 100644 index b9f7401128..0000000000 --- a/ext/oci8/tests/lob_009.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -oci_lob_import()/read() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); -var_dump($blob->seek(10, OCI_SEEK_CUR)); -var_dump($blob->import(dirname(__FILE__)."/lob_009.txt")); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -while (!$row[0]->eof()) { - var_dump($row[0]->read(1024)); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -bool(true) -bool(true) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(43) "this -is -a -test -file for -test lob_009.phpt -" -Done diff --git a/ext/oci8/tests/lob_009.txt b/ext/oci8/tests/lob_009.txt deleted file mode 100644 index f57bc8af37..0000000000 --- a/ext/oci8/tests/lob_009.txt +++ /dev/null @@ -1,6 +0,0 @@ -this -is -a -test -file for -test lob_009.phpt diff --git a/ext/oci8/tests/lob_010.phpt b/ext/oci8/tests/lob_010.phpt deleted file mode 100644 index 59f3e145f2..0000000000 --- a/ext/oci8/tests/lob_010.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -oci_lob_save() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob->save("string")); -var_dump($blob->save("string", 3)); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -$row = oci_fetch_array($s); - -while (!$row[0]->eof()) { - var_dump($row[0]->read(1024)); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -bool(true) -bool(true) -string(9) "strstring" -Done diff --git a/ext/oci8/tests/lob_011.phpt b/ext/oci8/tests/lob_011.phpt deleted file mode 100644 index b074e1730e..0000000000 --- a/ext/oci8/tests/lob_011.phpt +++ /dev/null @@ -1,78 +0,0 @@ ---TEST-- -oci_lob_copy() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (id, blob) - VALUES (1, empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob->write("some string here. string, I said")); -oci_commit($c); - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (id, blob) - VALUES (2, empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 1"; -$s = oci_parse($c, $select_sql); -oci_execute($s); - -$row1 = oci_fetch_array($s); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -$row2 = oci_fetch_array($s); - -var_dump(oci_lob_copy($row2[0], $row1[0])); -var_dump($row1[0]->read(100)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row2 = oci_fetch_array($s, OCI_RETURN_LOBS)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -int(32) -bool(true) -string(32) "some string here. string, I said" -array(2) { - [0]=> - string(32) "some string here. string, I said" - ["BLOB"]=> - string(32) "some string here. string, I said" -} -Done diff --git a/ext/oci8/tests/lob_012.phpt b/ext/oci8/tests/lob_012.phpt deleted file mode 100644 index 2061969bc4..0000000000 --- a/ext/oci8/tests/lob_012.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -oci_lob_export() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -$blob; - -var_dump($blob->write("test string is here\nnew string")); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -$row = oci_fetch_array($s); - -var_dump($row[0]->export(dirname(__FILE__)."/lob_012.tmp", 3, 10)); - -var_dump(file_get_contents(dirname(__FILE__)."/lob_012.tmp")); - -@unlink(dirname(__FILE__)."/lob_012.tmp"); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -int(30) -bool(true) -string(10) "t string i" -Done diff --git a/ext/oci8/tests/lob_013.phpt b/ext/oci8/tests/lob_013.phpt deleted file mode 100644 index c56de56198..0000000000 --- a/ext/oci8/tests/lob_013.phpt +++ /dev/null @@ -1,54 +0,0 @@ ---TEST-- -lob buffering ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob->write("test")); -var_dump($blob->getBuffering()); -var_dump($blob->setBuffering(true)); -var_dump($blob->write("test")); -var_dump($blob->getBuffering()); -var_dump($blob->flush()); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name.""; -$s = oci_parse($c, $select_sql); -oci_execute($s); - -$row = oci_fetch_array($s, OCI_RETURN_LOBS); - -var_dump($row[0]); - - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -int(4) -bool(false) -bool(true) -int(4) -bool(true) -bool(true) -string(8) "testtest" -Done diff --git a/ext/oci8/tests/lob_014.phpt b/ext/oci8/tests/lob_014.phpt deleted file mode 100644 index 60ed945312..0000000000 --- a/ext/oci8/tests/lob_014.phpt +++ /dev/null @@ -1,58 +0,0 @@ ---TEST-- -oci_lob_free()/close() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -$blob; - -var_dump($blob->write("test")); -var_dump($blob->close()); -var_dump($blob->write("test")); -var_dump($blob->free()); -var_dump($blob->write("test")); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name.""; -$s = oci_parse($c, $select_sql); -oci_execute($s); - -var_dump(oci_fetch_array($s, OCI_NUM + OCI_RETURN_LOBS)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -int(4) - -Warning: OCI-Lob::close(): ORA-22289: cannot perform operation on an unopened file or LOB in %slob_014.php on line %d -bool(false) -int(4) -bool(true) - -Warning: OCI-Lob::write(): %d is not a valid oci8 descriptor resource in %slob_014.php on line %d -bool(false) -array(1) { - [0]=> - string(8) "testtest" -} -Done diff --git a/ext/oci8/tests/lob_015.phpt b/ext/oci8/tests/lob_015.phpt deleted file mode 100644 index 297d5b4971..0000000000 --- a/ext/oci8/tests/lob_015.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -various tests with wrong param count ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB,1,2,3); -$blob = oci_new_descriptor($c); -$int = 1; -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB,4); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB,4,5); -oci_bind_by_name($statement,":v_blob", $int,-1); -oci_bind_by_name($statement,":v_blob", $int); -oci_bind_by_name($statement,":v_blob"); -oci_bind_by_name($statement); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: oci_new_descriptor() expects at most 2 parameters, 5 given in %s on line %d - -Warning: oci_bind_by_name() expects at most 5 parameters, 6 given in %s on line %d - -Warning: oci_bind_by_name() expects at most 5 parameters, 7 given in %s on line %d - -Warning: oci_bind_by_name() expects at least 3 parameters, 2 given in %s on line %d - -Warning: oci_bind_by_name() expects at least 3 parameters, 1 given in %s on line %d - -Warning: oci_execute(): ORA-00932: inconsistent datatypes: expected NUMBER got BLOB in %s on line %d -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -Done diff --git a/ext/oci8/tests/lob_016.phpt b/ext/oci8/tests/lob_016.phpt deleted file mode 100644 index 642e7195ef..0000000000 --- a/ext/oci8/tests/lob_016.phpt +++ /dev/null @@ -1,67 +0,0 @@ ---TEST-- -returning multiple lobs ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -$create = "CREATE table lob_test(lob_1 BLOB, lob_2 BLOB)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$init = "INSERT INTO lob_test VALUES(EMPTY_BLOB(), EMPTY_BLOB())"; -$statement = oci_parse($c, $init); -oci_execute($statement); - -$select = "SELECT * FROM lob_test FOR UPDATE"; -$statement = oci_parse($c, $select); -oci_execute($statement, OCI_DEFAULT); - -$row = oci_fetch_assoc($statement); - -$row['LOB_1']->write("first"); -$row['LOB_2']->write("second"); - -unset($row); - -oci_commit($c); - -$select = "SELECT * FROM lob_test FOR UPDATE"; -$statement = oci_parse($c, $select); -oci_execute($statement, OCI_DEFAULT); - -$row = oci_fetch_assoc($statement); - -var_dump($row); -var_dump($row['LOB_1']->load()); -var_dump($row['LOB_2']->load()); - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -echo "Done\n"; - -?> ---EXPECTF-- -array(2) { - ["LOB_1"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["LOB_2"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(5) "first" -string(6) "second" -Done diff --git a/ext/oci8/tests/lob_017.phpt b/ext/oci8/tests/lob_017.phpt deleted file mode 100644 index ed12cc4685..0000000000 --- a/ext/oci8/tests/lob_017.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -returning multiple lobs (using persistent connection) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$c = oci_pconnect($user, $password, $dbase); - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -$create = "CREATE table lob_test(lob_1 BLOB, lob_2 BLOB)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$init = "INSERT INTO lob_test VALUES(EMPTY_BLOB(), EMPTY_BLOB())"; -$statement = oci_parse($c, $init); -oci_execute($statement); - -$select = "SELECT * FROM lob_test FOR UPDATE"; -$statement = oci_parse($c, $select); -oci_execute($statement, OCI_DEFAULT); - -$row = oci_fetch_assoc($statement); - -$row['LOB_1']->write("first"); -$row['LOB_2']->write("second"); - -unset($row); - -oci_commit($c); - -$select = "SELECT * FROM lob_test FOR UPDATE"; -$statement = oci_parse($c, $select); -oci_execute($statement, OCI_DEFAULT); - -$row = oci_fetch_assoc($statement); - -var_dump($row); -var_dump($row['LOB_1']->load()); -var_dump($row['LOB_2']->load()); - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -echo "Done\n"; - -?> ---EXPECTF-- -array(2) { - ["LOB_1"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["LOB_2"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(5) "first" -string(6) "second" -Done diff --git a/ext/oci8/tests/lob_018.phpt b/ext/oci8/tests/lob_018.phpt deleted file mode 100644 index 35cec4bd7d..0000000000 --- a/ext/oci8/tests/lob_018.phpt +++ /dev/null @@ -1,67 +0,0 @@ ---TEST-- -fetching the same lob several times ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -$create = "CREATE table lob_test(mykey NUMBER, lob_1 CLOB)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$init = "INSERT INTO lob_test (mykey, lob_1) VALUES(1, EMPTY_CLOB()) RETURNING lob_1 INTO :mylob"; -$statement = oci_parse($c, $init); -$clob = oci_new_descriptor($c, OCI_D_LOB); -oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB); -oci_execute($statement, OCI_DEFAULT); -$clob->save("data"); - -oci_commit($c); - -$init = "INSERT INTO lob_test (mykey, lob_1) VALUES(2, EMPTY_CLOB()) RETURNING lob_1 INTO :mylob"; -$statement = oci_parse($c, $init); -$clob = oci_new_descriptor($c, OCI_D_LOB); -oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB); -oci_execute($statement, OCI_DEFAULT); -$clob->save("long data"); - -oci_commit($c); - - -$query = 'SELECT * FROM lob_test ORDER BY mykey ASC'; -$statement = oci_parse ($c, $query); -oci_execute($statement, OCI_DEFAULT); - -while ($row = oci_fetch_array($statement, OCI_ASSOC)) { - $result = $row['LOB_1']->load(); - var_dump($result); -} - -$query = 'SELECT * FROM lob_test ORDER BY mykey DESC'; -$statement = oci_parse ($c, $query); -oci_execute($statement, OCI_DEFAULT); - -while ($row = oci_fetch_array($statement, OCI_ASSOC)) { - $result = $row['LOB_1']->load(); - var_dump($result); -} - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -echo "Done\n"; - -?> ---EXPECTF-- -string(4) "data" -string(9) "long data" -string(9) "long data" -string(4) "data" -Done diff --git a/ext/oci8/tests/lob_019.phpt b/ext/oci8/tests/lob_019.phpt Binary files differdeleted file mode 100644 index fb9a3c8188..0000000000 --- a/ext/oci8/tests/lob_019.phpt +++ /dev/null diff --git a/ext/oci8/tests/lob_020.phpt b/ext/oci8/tests/lob_020.phpt Binary files differdeleted file mode 100644 index edd0f02490..0000000000 --- a/ext/oci8/tests/lob_020.phpt +++ /dev/null diff --git a/ext/oci8/tests/lob_021.phpt b/ext/oci8/tests/lob_021.phpt deleted file mode 100644 index 32ef6f9fef..0000000000 --- a/ext/oci8/tests/lob_021.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -oci_lob_free()/close() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -$blob; - -var_dump($blob->write("test")); -var_dump($blob->close()); -var_dump($blob->write("test")); -var_dump(oci_free_descriptor($blob)); -var_dump($blob->write("test")); - -var_dump(oci_free_descriptor($blob)); -var_dump(oci_free_descriptor(new stdclass)); - -$blob = oci_new_descriptor($c,OCI_D_LOB); -unset($blob->descriptor); -var_dump(oci_free_descriptor($blob)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name.""; -$s = oci_parse($c, $select_sql); -oci_execute($s); - -var_dump(oci_fetch_array($s, OCI_NUM + OCI_RETURN_LOBS)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -int(4) - -Warning: OCI-Lob::close(): ORA-22289: cannot perform operation on an unopened file or LOB in %s on line %d -bool(false) -int(4) -bool(true) - -Warning: OCI-Lob::write(): %d is not a valid oci8 descriptor resource in %s on line %d -bool(false) - -Warning: oci_free_descriptor(): %d is not a valid oci8 descriptor resource in %s on line %d -bool(false) - -Warning: oci_free_descriptor() expects parameter 1 to be OCI-Lob, object given in %s on line %d -NULL - -Warning: oci_free_descriptor(): Unable to find descriptor property in %s on line %d -bool(false) -array(1) { - [0]=> - string(8) "testtest" -} -Done diff --git a/ext/oci8/tests/lob_022.phpt b/ext/oci8/tests/lob_022.phpt deleted file mode 100644 index 5fb9dfab0e..0000000000 --- a/ext/oci8/tests/lob_022.phpt +++ /dev/null @@ -1,80 +0,0 @@ ---TEST-- -fetching the same lob several times ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -$create = "CREATE table lob_test(mykey NUMBER, lob_1 CLOB)"; -$statement = oci_parse($c, $create); -oci_execute($statement); - -$init = "INSERT INTO lob_test (mykey, lob_1) VALUES(1, EMPTY_CLOB()) RETURNING lob_1 INTO :mylob"; -$statement = oci_parse($c, $init); -$clob = oci_new_descriptor($c, OCI_D_LOB); -oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB); -oci_execute($statement, OCI_DEFAULT); -$clob->save(); -oci_lob_save(); -oci_lob_save($clob, "data"); -unset($clob->descriptor); -oci_lob_save($clob, "data"); - -oci_commit($c); - -$init = "INSERT INTO lob_test (mykey, lob_1) VALUES(2, EMPTY_CLOB()) RETURNING lob_1 INTO :mylob"; -$statement = oci_parse($c, $init); -$clob = oci_new_descriptor($c, OCI_D_LOB); -oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB); -oci_execute($statement, OCI_DEFAULT); -$clob->save("long data"); -$clob->save("long data", -1); -$clob->save("long data", 0); - -oci_commit($c); - - -$query = 'SELECT * FROM lob_test ORDER BY mykey ASC'; -$statement = oci_parse ($c, $query); -oci_execute($statement, OCI_DEFAULT); - -while ($row = oci_fetch_array($statement, OCI_ASSOC)) { - $result = $row['LOB_1']->load(); - var_dump($result); -} - -$query = 'SELECT * FROM lob_test ORDER BY mykey DESC'; -$statement = oci_parse ($c, $query); -oci_execute($statement, OCI_DEFAULT); - -while ($row = oci_fetch_array($statement, OCI_ASSOC)) { - $result = $row['LOB_1']->load(); - var_dump($result); -} - -$drop = "DROP table lob_test"; -$statement = oci_parse($c, $drop); -@oci_execute($statement); - -echo "Done\n"; - -?> ---EXPECTF-- -Warning: OCI-Lob::save() expects at least 1 parameter, 0 given in %s on line %d - -Warning: oci_lob_save() expects at least 2 parameters, 0 given in %s on line %d - -Warning: oci_lob_save(): Unable to find descriptor property in %s on line %d - -Warning: OCI-Lob::save(): Offset parameter must be greater than or equal to 0 in %s on line %d -string(4) "data" -string(9) "long data" -string(9) "long data" -string(4) "data" -Done diff --git a/ext/oci8/tests/lob_023.phpt b/ext/oci8/tests/lob_023.phpt deleted file mode 100644 index 0c352956de..0000000000 --- a/ext/oci8/tests/lob_023.phpt +++ /dev/null @@ -1,84 +0,0 @@ ---TEST-- -oci_lob_import()/read() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); -var_dump($blob->seek(10, OCI_SEEK_CUR)); -var_dump($blob->import(dirname(__FILE__)."/lob_009.txt")); -var_dump($blob->import()); -var_dump(oci_lob_import($blob)); -var_dump(oci_lob_import($blob, dirname(__FILE__)."/lob_009.txt")); -unset($blob->descriptor); -var_dump(oci_lob_import($blob, dirname(__FILE__)."/lob_009.txt")); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -while (!$row[0]->eof()) { - var_dump($row[0]->read(1024)); -} - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -bool(true) -bool(true) - -Warning: OCI-Lob::import() expects exactly 1 parameter, 0 given in %s on line %d -NULL - -Warning: oci_lob_import() expects exactly 2 parameters, 1 given in %s on line %d -NULL -bool(true) - -Warning: oci_lob_import(): Unable to find descriptor property in %s on line %d -bool(false) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(43) "this -is -a -test -file for -test lob_009.phpt -" -Done diff --git a/ext/oci8/tests/lob_024.phpt b/ext/oci8/tests/lob_024.phpt deleted file mode 100644 index 9a7f53240d..0000000000 --- a/ext/oci8/tests/lob_024.phpt +++ /dev/null @@ -1,75 +0,0 @@ ---TEST-- -oci_lob_load() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump($blob->size()); -var_dump($blob->write(str_repeat("string.", 1000))); -var_dump($blob->size()); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump(strlen($row[0]->load())); -var_dump(strlen(oci_lob_load($row[0]))); -var_dump(oci_lob_load()); -unset($row[0]->descriptor); -var_dump(oci_lob_load($row[0])); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(0) -int(7000) -int(7000) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -int(7000) -int(7000) - -Warning: oci_lob_load() expects exactly 1 parameter, 0 given in %s on line %d -NULL - -Warning: oci_lob_load(): Unable to find descriptor property in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/lob_025.phpt b/ext/oci8/tests/lob_025.phpt deleted file mode 100644 index 5b5e845a7a..0000000000 --- a/ext/oci8/tests/lob_025.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -oci_lob_read() tests ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob->size()); -var_dump($blob->write(str_repeat("string.", 1000))); -var_dump($blob->size()); -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump(oci_lob_read($row[0], 2)); -var_dump(oci_lob_read($row[0])); -var_dump(oci_lob_read()); -var_dump(oci_lob_eof($row[0])); -var_dump(oci_lob_eof()); - -unset($row[0]->descriptor); -var_dump(oci_lob_read($row[0],1)); -var_dump(oci_lob_eof($row[0])); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -int(0) -int(7000) -int(7000) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} -string(2) "st" - -Warning: oci_lob_read() expects exactly 2 parameters, 1 given in %s on line %d -NULL - -Warning: oci_lob_read() expects exactly 2 parameters, 0 given in %s on line %d -NULL -bool(false) - -Warning: oci_lob_eof() expects exactly 1 parameter, 0 given in %s on line %d -NULL - -Warning: oci_lob_read(): Unable to find descriptor property in %s on line %d -bool(false) - -Warning: oci_lob_eof(): Unable to find descriptor property in %s on line %d -bool(false) -Done diff --git a/ext/oci8/tests/lob_026.phpt b/ext/oci8/tests/lob_026.phpt deleted file mode 100644 index 157d78a2b6..0000000000 --- a/ext/oci8/tests/lob_026.phpt +++ /dev/null @@ -1,100 +0,0 @@ ---TEST-- -oci_lob_seek()/rewind()/append() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$schema.$table_name." (blob) - VALUES (empty_blob()) - RETURNING - blob - INTO :v_blob "; - -$statement = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($statement, OCI_DEFAULT); - -var_dump($blob); - -var_dump(oci_lob_write($blob, "test")); -var_dump(oci_lob_rewind()); -var_dump(oci_lob_rewind($blob)); -var_dump(oci_lob_write($blob, "str")); -var_dump(oci_lob_seek(10, OCI_SEEK_SET)); -var_dump(oci_lob_seek($blob, 10, OCI_SEEK_SET)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -var_dump($row = oci_fetch_array($s)); - -var_dump(oci_lob_append()); -var_dump(oci_lob_append($blob)); -var_dump(oci_lob_append($row[0], $blob)); -var_dump(oci_lob_read(10000)); -var_dump(oci_lob_read($row[0], 10000)); - -oci_commit($c); - -$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE"; -$s = oci_parse($c, $select_sql); -oci_execute($s, OCI_DEFAULT); - -$row = oci_fetch_array($s); - -var_dump(oci_lob_read($row[0], 10000)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECTF-- -object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) -} -int(4) - -Warning: oci_lob_rewind() expects exactly 1 parameter, 0 given in %s on line %d -NULL -bool(true) -int(3) - -Warning: oci_lob_seek() expects parameter 1 to be OCI-Lob, integer given in %s on line %d -NULL -bool(true) -array(2) { - [0]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } - ["BLOB"]=> - object(OCI-Lob)#%d (1) { - ["descriptor"]=> - resource(%d) of type (oci8 descriptor) - } -} - -Warning: oci_lob_append() expects exactly 2 parameters, 0 given in %s on line %d -NULL - -Warning: oci_lob_append() expects exactly 2 parameters, 1 given in %s on line %d -NULL -bool(true) - -Warning: oci_lob_read() expects exactly 2 parameters, 1 given in %s on line %d -NULL -string(4) "strt" -string(8) "strtstrt" -Done diff --git a/ext/oci8/tests/lob_temp.phpt b/ext/oci8/tests/lob_temp.phpt deleted file mode 100644 index cad2d39058..0000000000 --- a/ext/oci8/tests/lob_temp.phpt +++ /dev/null @@ -1,36 +0,0 @@ ---TEST-- -temporary lobs ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$blob = oci_new_descriptor($c,OCI_D_LOB); -var_dump($blob->writeTemporary("test")); -var_dump($blob->load()); -var_dump($blob->seek(0, SEEK_SET)); -var_dump($blob->read(2)); - -$c = oci_pconnect($user, $password, $dbase); - -$blob = oci_new_descriptor($c,OCI_D_LOB); -var_dump($blob->writeTemporary("test")); -var_dump($blob->load()); -var_dump($blob->seek(0, SEEK_SET)); -var_dump($blob->read(2)); - -echo "Done\n"; - -?> ---EXPECTF-- -bool(true) -string(4) "test" -bool(true) -string(2) "te" -bool(true) -string(4) "test" -bool(true) -string(2) "te" -Done diff --git a/ext/oci8/tests/lob_temp1.phpt b/ext/oci8/tests/lob_temp1.phpt deleted file mode 100644 index 2482d65f64..0000000000 --- a/ext/oci8/tests/lob_temp1.phpt +++ /dev/null @@ -1,32 +0,0 @@ ---TEST-- -closing temporary lobs ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; - -$blob = oci_new_descriptor($c,OCI_D_LOB); -var_dump($blob->writeTemporary("test")); -var_dump($blob->load()); -var_dump($blob->close()); - -$c = oci_pconnect($user, $password, $dbase); - -$blob = oci_new_descriptor($c,OCI_D_LOB); -var_dump($blob->writeTemporary("test")); -var_dump($blob->load()); -var_dump($blob->close()); - -echo "Done\n"; - -?> ---EXPECTF-- -bool(true) -string(4) "test" -bool(true) -bool(true) -string(4) "test" -bool(true) -Done diff --git a/ext/oci8/tests/num.phpt b/ext/oci8/tests/num.phpt deleted file mode 100644 index 3c333b4e3a..0000000000 --- a/ext/oci8/tests/num.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -oci_num_*() family ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(ocirowcount($s)); -var_dump(oci_num_rows($s)); -var_dump(ocinumcols($s)); -var_dump(oci_num_fields($s)); - -$delete_sql = "DELETE FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $delete_sql))) { - die("oci_parse(delete) failed!\n"); -} - -if (!oci_execute($s)) { - die("oci_execute(delete) failed!\n"); -} -oci_commit($c); - -var_dump(oci_num_rows($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; - -?> ---EXPECT-- -int(0) -int(0) -int(5) -int(5) -int(3) -Done diff --git a/ext/oci8/tests/oci_execute_segfault.phpt b/ext/oci8/tests/oci_execute_segfault.phpt deleted file mode 100644 index 3859f4ffe0..0000000000 --- a/ext/oci8/tests/oci_execute_segfault.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_execute() segfault after repeated bind ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__).'/connect.inc'; -require dirname(__FILE__).'/create_table.inc'; - -$ora_sql = "INSERT INTO - ".$table_name." (blob, clob) - VALUES (empty_blob(), empty_clob()) - RETURNING - blob - INTO :v_blob "; - -$s = oci_parse($c,$ora_sql); -$blob = oci_new_descriptor($c,OCI_D_LOB); -oci_bind_by_name($s,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($s); - -oci_bind_by_name($s,":v_blob", $blob,-1,OCI_B_BLOB); -oci_execute($s); - -echo "Done\n"; - -?> ---EXPECT-- -Done diff --git a/ext/oci8/tests/old_oci_close.phpt b/ext/oci8/tests/old_oci_close.phpt deleted file mode 100644 index f15b7febea..0000000000 --- a/ext/oci8/tests/old_oci_close.phpt +++ /dev/null @@ -1,23 +0,0 @@ ---TEST-- -oci8.old_oci_close_semantics On ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.old_oci_close_semantics=1 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -var_dump($c); -var_dump(oci_close($c)); -var_dump(oci_parse($c, "select 1 from dual")); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -NULL -resource(%d) of type (oci8 statement) -Done diff --git a/ext/oci8/tests/old_oci_close1.phpt b/ext/oci8/tests/old_oci_close1.phpt deleted file mode 100644 index 9af2eeb398..0000000000 --- a/ext/oci8/tests/old_oci_close1.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -oci8.old_oci_close_semantics Off ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.old_oci_close_semantics=0 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -var_dump($c); -var_dump(oci_close($c)); -var_dump(oci_parse($c, "select 1 from dual")); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -bool(true) - -Warning: oci_parse() expects parameter 1 to be resource, null given in %s on line %d -NULL -Done diff --git a/ext/oci8/tests/password.phpt b/ext/oci8/tests/password.phpt deleted file mode 100644 index a31843cfd0..0000000000 --- a/ext/oci8/tests/password.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_password_change() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$new_password = "test"; -var_dump(oci_password_change($dbase, $user, $password, $new_password)); - -if (!empty($dbase)) { - var_dump($new_c = ocilogon($user,$new_password,$dbase)); -} -else { - var_dump($new_c = ocilogon($user,$new_password)); -} - -var_dump(oci_password_change($dbase, $user, $new_password, $password)); - - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -Done diff --git a/ext/oci8/tests/password_new.phpt b/ext/oci8/tests/password_new.phpt deleted file mode 100644 index a31843cfd0..0000000000 --- a/ext/oci8/tests/password_new.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_password_change() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$new_password = "test"; -var_dump(oci_password_change($dbase, $user, $password, $new_password)); - -if (!empty($dbase)) { - var_dump($new_c = ocilogon($user,$new_password,$dbase)); -} -else { - var_dump($new_c = ocilogon($user,$new_password)); -} - -var_dump(oci_password_change($dbase, $user, $new_password, $password)); - - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -Done diff --git a/ext/oci8/tests/password_old.phpt b/ext/oci8/tests/password_old.phpt deleted file mode 100644 index d293fce870..0000000000 --- a/ext/oci8/tests/password_old.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -ocipasswordchange() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$new_password = "test"; -var_dump(ocipasswordchange($c, $user, $password, $new_password)); - -if (!empty($dbase)) { - var_dump($new_c = ocilogon($user,$new_password,$dbase)); -} -else { - var_dump($new_c = ocilogon($user,$new_password)); -} - -var_dump(ocipasswordchange($new_c, $user, $new_password, $password)); - - -echo "Done\n"; - -?> ---EXPECTF-- -bool(true) -resource(%d) of type (oci8 connection) -bool(true) -Done diff --git a/ext/oci8/tests/pecl_bug8816.phpt b/ext/oci8/tests/pecl_bug8816.phpt deleted file mode 100644 index c369711fcf..0000000000 --- a/ext/oci8/tests/pecl_bug8816.phpt +++ /dev/null @@ -1,98 +0,0 @@ ---TEST-- -PECL Bug #8816 (issue in php_oci_statement_fetch with more than one piecewise column) ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$create_1 = "CREATE TABLE t1 (id INTEGER, l1 LONG)"; -$create_2 = "CREATE TABLE t2 (id INTEGER, l2 LONG)"; -$drop_1 = "DROP TABLE t1"; -$drop_2 = "DROP TABLE t2"; - -$s1 = oci_parse($c, $drop_1); -$s2 = oci_parse($c, $drop_2); -@oci_execute($s1); -@oci_execute($s2); - -$s1 = oci_parse($c, $create_1); -$s2 = oci_parse($c, $create_2); -oci_execute($s1); -oci_execute($s2); - -$values = array("1234567890111111111", "122222222222222", "985456745674567654567654567654", "123456789", "987654321"); - -$i = 0; -foreach ($values as $val) { - $i++; - $insert = "INSERT INTO t1 VALUES($i, ".$val.")"; - $s = oci_parse($c, $insert); - oci_execute($s); -} - -foreach ($values as $val) { - $insert = "INSERT INTO t2 VALUES($i, ".$val.")"; - $s = oci_parse($c, $insert); - oci_execute($s); - $i--; -} - -$query =" -SELECT - t1.l1, t2.l2 -FROM -t1, t2 -WHERE -t1.id = t2.id -ORDER BY t1.id ASC -"; - -$sth = oci_parse($c, $query); -oci_execute($sth); - -while ( $row = oci_fetch_assoc($sth) ) { - var_dump($row); -} - -$s1 = oci_parse($c, $drop_1); -$s2 = oci_parse($c, $drop_2); -@oci_execute($s1); -@oci_execute($s2); - -echo "Done\n"; - -?> ---EXPECT-- -array(2) { - ["L1"]=> - string(19) "1234567890111111111" - ["L2"]=> - string(9) "987654321" -} -array(2) { - ["L1"]=> - string(15) "122222222222222" - ["L2"]=> - string(9) "123456789" -} -array(2) { - ["L1"]=> - string(30) "985456745674567654567654567654" - ["L2"]=> - string(30) "985456745674567654567654567654" -} -array(2) { - ["L1"]=> - string(9) "123456789" - ["L2"]=> - string(15) "122222222222222" -} -array(2) { - ["L1"]=> - string(9) "987654321" - ["L2"]=> - string(19) "1234567890111111111" -} -Done diff --git a/ext/oci8/tests/persistent.phpt b/ext/oci8/tests/persistent.phpt deleted file mode 100644 index 884cd35a4c..0000000000 --- a/ext/oci8/tests/persistent.phpt +++ /dev/null @@ -1,26 +0,0 @@ ---TEST-- -reusing persistent connections ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -var_dump(oci_pconnect($user, $password, $dbase)); -var_dump(oci_pconnect($user, $password, $dbase)); -var_dump(oci_pconnect($user, $password, $dbase)); -var_dump(oci_connect($user, $password, $dbase)); -var_dump(oci_connect($user, $password, $dbase)); -var_dump(oci_connect($user, $password, $dbase)); - -echo "Done\n"; -?> ---EXPECTF-- -resource(%d) of type (oci8 persistent connection) -resource(%d) of type (oci8 persistent connection) -resource(%d) of type (oci8 persistent connection) -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -resource(%d) of type (oci8 connection) -Done diff --git a/ext/oci8/tests/prefetch.phpt b/ext/oci8/tests/prefetch.phpt deleted file mode 100644 index fa4b8fdc60..0000000000 --- a/ext/oci8/tests/prefetch.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -oci_set_prefetch() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); - } -} - -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = oci_parse($c, $select_sql))) { - die("oci_parse(select) failed!\n"); -} - -var_dump(oci_set_prefetch($s, 10)); - -if (!oci_execute($s)) { - die("oci_execute(select) failed!\n"); -} - -var_dump(oci_fetch($s)); - -var_dump(oci_num_rows($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -bool(true) -int(1) -Done diff --git a/ext/oci8/tests/prefetch_old.phpt b/ext/oci8/tests/prefetch_old.phpt deleted file mode 100644 index cb9cb390e6..0000000000 --- a/ext/oci8/tests/prefetch_old.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -ocisetprefetch() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; - -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; - -if (!($s = ociparse($c, $insert_sql))) { - die("ociparse(insert) failed!\n"); -} - -for ($i = 0; $i<3; $i++) { - if (!ociexecute($s)) { - die("ociexecute(insert) failed!\n"); - } -} - -if (!ocicommit($c)) { - die("ocicommit() failed!\n"); -} - -$select_sql = "SELECT * FROM ".$schema.$table_name.""; - -if (!($s = ociparse($c, $select_sql))) { - die("ociparse(select) failed!\n"); -} - -var_dump(ocisetprefetch($s, 10)); - -if (!ociexecute($s)) { - die("ociexecute(select) failed!\n"); -} - -var_dump(ocifetch($s)); - -var_dump(ocirowcount($s)); - -require dirname(__FILE__).'/drop_table.inc'; - -echo "Done\n"; -?> ---EXPECT-- -bool(true) -bool(true) -int(1) -Done diff --git a/ext/oci8/tests/privileged_connect.phpt b/ext/oci8/tests/privileged_connect.phpt deleted file mode 100644 index 39122240a7..0000000000 --- a/ext/oci8/tests/privileged_connect.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -privileged connect tests ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -oci_connect("", "", "", false, OCI_SYSOPER); -oci_connect("", "", "", false, OCI_SYSDBA); -oci_connect("", "", "", false, -1); -oci_connect("", "", "", false, "qwe"); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_connect(): Privileged connect is disabled. Enable oci8.privileged_connect to be able to connect as SYSOPER or SYSDBA in %s on line %d - -Warning: oci_connect(): Privileged connect is disabled. Enable oci8.privileged_connect to be able to connect as SYSOPER or SYSDBA in %s on line %d - -Warning: oci_connect(): Invalid session mode specified (-1) in %s on line %d - -Warning: oci_connect() expects parameter 5 to be long, string given in %s on line %d -Done diff --git a/ext/oci8/tests/privileged_connect1.phpt b/ext/oci8/tests/privileged_connect1.phpt deleted file mode 100644 index a05a21093a..0000000000 --- a/ext/oci8/tests/privileged_connect1.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -privileged connect tests ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---INI-- -oci8.privileged_connect=1 ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -oci_connect("", "", "", false, OCI_SYSOPER); -oci_connect("", "", "", false, OCI_SYSDBA); -oci_connect("", "", "", false, -1); -oci_connect("", "", "", false, "qwe"); - -echo "Done\n"; -?> ---EXPECTF-- -Warning: oci_connect(): ORA-01031: insufficient privileges in %s on line %d - -Warning: oci_connect(): ORA-01031: insufficient privileges in %s on line %d - -Warning: oci_connect(): Invalid session mode specified (-1) in %s on line %d - -Warning: oci_connect() expects parameter 5 to be long, string given in %s on line %d -Done diff --git a/ext/oci8/tests/select_null.phpt b/ext/oci8/tests/select_null.phpt deleted file mode 100644 index 87c5b815fd..0000000000 --- a/ext/oci8/tests/select_null.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -SELECTing NULL values ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$pc = oci_pconnect($user, $password, $dbase); - -$stmt = oci_parse($pc, "select NULL from dual"); -oci_execute($stmt); -var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS)); - -echo "Done\n"; -?> ---EXPECT-- -array(2) { - [0]=> - NULL - ["NULL"]=> - NULL -} -Done diff --git a/ext/oci8/tests/serverversion.phpt b/ext/oci8/tests/serverversion.phpt deleted file mode 100644 index bf32fe4b54..0000000000 --- a/ext/oci8/tests/serverversion.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -oci_server_version() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump($c = oci_connect($user, $password, $dbase)); -} -else { - var_dump($c = oci_connect($user, $password)); -} - -$v = oci_server_version($c); -var_dump(str_replace("\n", "", $v)); - -$v = ociserverversion($c); -var_dump(str_replace("\n", "", $v)); - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -string(%d) "%s" -string(%d) "%s" -Done diff --git a/ext/oci8/tests/skipif.inc b/ext/oci8/tests/skipif.inc deleted file mode 100644 index ed0992c8d9..0000000000 --- a/ext/oci8/tests/skipif.inc +++ /dev/null @@ -1,10 +0,0 @@ -<?php - -if (!extension_loaded('oci8')) die("skip oci8 extension is not available\n"); - -/* - * Remove or comment this line to run tests - * - * */ -die("skip change default login/password\n"); -?> diff --git a/ext/oci8/tests/statement_cache.phpt b/ext/oci8/tests/statement_cache.phpt deleted file mode 100644 index 19e69d4c21..0000000000 --- a/ext/oci8/tests/statement_cache.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -statement cache ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$pc = oci_pconnect($user, $password, $dbase); - -$stmt = oci_parse($pc, "select 1+3 from dual"); -oci_execute($stmt); -var_dump(oci_fetch_array($stmt)); - -$stmt = oci_parse($pc, "select 1+3 from dual"); -oci_execute($stmt); -var_dump(oci_fetch_array($stmt)); - -echo "Done\n"; -?> ---EXPECTF-- -array(2) { - [0]=> - string(1) "4" - ["1+3"]=> - string(1) "4" -} -array(2) { - [0]=> - string(1) "4" - ["1+3"]=> - string(1) "4" -} -Done diff --git a/ext/oci8/tests/statement_type.phpt b/ext/oci8/tests/statement_type.phpt deleted file mode 100644 index 45221a6c77..0000000000 --- a/ext/oci8/tests/statement_type.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -oci_statement_type() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump($c = oci_connect($user, $password, $dbase)); -} -else { - var_dump($c = oci_connect($user, $password)); -} - -$sqls = Array( - "SELECT * FROM table", - "DELETE FROM table WHERE id = 1", - "INSERT INTO table VALUES(1)", - "UPDATE table SET id = 1", - "DROP TABLE table", - "CREATE TABLE table (id NUMBER)", - "WRONG SYNTAX", - "" -); - -foreach ($sqls as $sql) { - $s = oci_parse($c, $sql); - var_dump(oci_statement_type($s)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -string(6) "SELECT" -string(6) "DELETE" -string(6) "INSERT" -string(6) "UPDATE" -string(4) "DROP" -string(6) "CREATE" -string(7) "UNKNOWN" -string(7) "UNKNOWN" -Done diff --git a/ext/oci8/tests/statement_type_old.phpt b/ext/oci8/tests/statement_type_old.phpt deleted file mode 100644 index 13da41bf76..0000000000 --- a/ext/oci8/tests/statement_type_old.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -ocistatementtype() ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -if (!empty($dbase)) { - var_dump($c = ocilogon($user, $password, $dbase)); -} -else { - var_dump($c = ocilogon($user, $password)); -} - -$sqls = Array( - "SELECT * FROM table", - "DELETE FROM table WHERE id = 1", - "INSERT INTO table VALUES(1)", - "UPDATE table SET id = 1", - "DROP TABLE table", - "CREATE TABLE table (id NUMBER)", - "WRONG SYNTAX", - "" -); - -foreach ($sqls as $sql) { - $s = ociparse($c, $sql); - var_dump(ocistatementtype($s)); -} - -echo "Done\n"; - -?> ---EXPECTF-- -resource(%d) of type (oci8 connection) -string(6) "SELECT" -string(6) "DELETE" -string(6) "INSERT" -string(6) "UPDATE" -string(4) "DROP" -string(6) "CREATE" -string(7) "UNKNOWN" -string(7) "UNKNOWN" -Done diff --git a/ext/oci8/tests/test.gif b/ext/oci8/tests/test.gif Binary files differdeleted file mode 100644 index f352c7308f..0000000000 --- a/ext/oci8/tests/test.gif +++ /dev/null diff --git a/ext/oci8/tests/test.txt b/ext/oci8/tests/test.txt deleted file mode 100644 index fa9e8d2c2f..0000000000 --- a/ext/oci8/tests/test.txt +++ /dev/null @@ -1,9 +0,0 @@ -Feel so good, I feel so fine -Love that little lady always on my mind -She gives me loving every night and day -Never gonna leave her, never going away - -Someone to love me -You know she makes me feel all right, yeah (all right) -Someone to need me -Love me every single night, yeah diff --git a/ext/oci8/tests/uncommitted.phpt b/ext/oci8/tests/uncommitted.phpt deleted file mode 100644 index 3c341c8cb4..0000000000 --- a/ext/oci8/tests/uncommitted.phpt +++ /dev/null @@ -1,16 +0,0 @@ ---TEST-- -uncommitted connection ---SKIPIF-- -<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> ---FILE-- -<?php - -require dirname(__FILE__)."/connect.inc"; - -$stmt = oci_parse($c, "select 1 from dual"); -oci_execute($stmt, OCI_DEFAULT); - -echo "Done\n"; -?> ---EXPECTF-- -Done |
