/PHP-8.1/ext/oci8/tests/ |
H A D | bind_empty.phpt | 11 $statement = oci_parse($c, $drop); 15 $statement = oci_parse($c, $create); 22 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name"); 30 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name"); 37 $stmt = oci_parse($c, "INSERT INTO bind_empty_tab (NAME) VALUES ('abc')"); 40 $stmt = oci_parse($c, "INSERT INTO bind_empty_tab (NAME) VALUES ('def')"); 49 $stid = oci_parse($c, "select * from bind_empty_tab order by 1"); 62 $stid = oci_parse($c, "select * from bind_empty_tab order by 1"); 70 $s = oci_parse($c, "begin :bv := null; end; "); 79 $s = oci_parse($c, "begin :bv := null; end; "); [all …]
|
H A D | bug38173.phpt | 20 $s1 = oci_parse($c, $drop_1); 21 $s2 = oci_parse($c, $drop_2); 25 $s1 = oci_parse($c, $create_1); 26 $s2 = oci_parse($c, $create_2); 32 $s = oci_parse($c, $insert); 38 $s = oci_parse($c, $insert); 50 $sth = oci_parse($c, $query); 60 $s1 = oci_parse($c, $drop_1); 61 $s2 = oci_parse($c, $drop_2);
|
H A D | pecl_bug8816.phpt | 20 $s1 = oci_parse($c, $drop_1); 21 $s2 = oci_parse($c, $drop_2); 25 $s1 = oci_parse($c, $create_1); 26 $s2 = oci_parse($c, $create_2); 36 $s = oci_parse($c, $insert); 42 $s = oci_parse($c, $insert); 57 $sth = oci_parse($c, $query); 64 $s1 = oci_parse($c, $drop_1); 65 $s2 = oci_parse($c, $drop_2);
|
H A D | lob_029.phpt | 32 $s = oci_parse($c, "drop table FileTest"); 35 $s = oci_parse($c, "drop directory TestDir"); 38 $s = oci_parse($c, "create directory TestDir as '$realdirname'"); 45 $s = oci_parse($c, "create table FileTest (FileNum number, FileDesc varchar2(30), Image bfile)"); 48 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (1, 'Description 1', bfi… 51 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (2, 'Description 2', bfi… 54 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (3, 'Description 3', bfi… 61 $s = oci_parse($c, "select count(*) numrows from FileTest"); 67 $s = oci_parse($c, "select * from FileTest order by FileNum"); 86 $s = oci_parse($c, "drop table FileTest"); [all …]
|
H A D | bind_long.phpt | 15 $stmt = oci_parse($c, "drop table phptestlng"); 18 $stmt = oci_parse($c, "create table phptestlng( id number(10), filetxt long)"); 23 $stmt = oci_parse ($c, "insert into phptestlng (id, filetxt) values (:id, :filetxt)"); 33 $stmt = oci_parse($c, "SELECT filetxt FROM phptestlng where id = 1"); 42 $stmt = oci_parse ($c, "insert into phptestlng (id, filetxt) values (:id, :filetxt)"); 51 $stmt = oci_parse($c, "SELECT filetxt FROM phptestlng where id = 2"); 58 $stmt = oci_parse($c, "drop table phptestlng");
|
H A D | drcp_functions.inc | 8 $statement = oci_parse($conn, $create_sql); 18 $s = oci_parse($conn, $insert); 26 $statement = oci_parse($conn, $ora_sql); 33 $s1 = oci_parse($conn,$update_stmt); 41 $s2 = oci_parse($conn,$sel_stmt); 51 $s2 = oci_parse($conn, $sel_stmt); 63 $s1 = oci_parse($conn,$set_stmt); 75 $s1 = oci_parse($c, $create_package_stmt); 89 $s2 = oci_parse($c, $package_body);
|
H A D | num.phpt | 22 if (!($s = oci_parse($c, $insert_sql))) { 23 die("oci_parse(insert) failed!\n"); 50 if (!($s = oci_parse($c, $select_sql))) { 51 die("oci_parse(select) failed!\n"); 78 if (!($s = oci_parse($c, $select_sql))) { 79 die("oci_parse(select) failed!\n"); 97 if (!($s = oci_parse($c, $select_sql))) { 98 die("oci_parse(select) failed!\n"); 115 if (!($s = oci_parse($c, $delete_sql))) { 116 die("oci_parse(delete) failed!\n");
|
H A D | lob_016.phpt | 16 $statement = oci_parse($c, $drop); 20 $statement = oci_parse($c, $create); 24 $statement = oci_parse($c, $init); 28 $statement = oci_parse($c, $select); 41 $statement = oci_parse($c, $select); 51 $statement = oci_parse($c, $drop);
|
H A D | bug35973.phpt | 15 $s1 = oci_parse($c, "drop table test_nclob"); 18 $s2 = oci_parse($c, "create table test_nclob (nc NCLOB)"); 21 $s3 = oci_parse($c, "insert into test_nclob (nc) values ('12345data')"); 24 $s3 = oci_parse($c, "select * from test_nclob"); 33 $s1 = oci_parse($c, "drop table test_nclob");
|
H A D | lob_017.phpt | 18 $statement = oci_parse($c, $drop); 22 $statement = oci_parse($c, $create); 26 $statement = oci_parse($c, $init); 30 $statement = oci_parse($c, $select); 43 $statement = oci_parse($c, $select); 53 $statement = oci_parse($c, $drop);
|
H A D | bug40415.phpt | 22 $s1 = oci_parse($c, $drop_1); 23 $s2 = oci_parse($c, $drop_2); 27 $s1 = oci_parse($c, $create_1); 28 $s2 = oci_parse($c, $create_2); 34 $s = oci_parse($c, $insert); 40 $s = oci_parse($c, $insert); 49 $stmt = oci_parse($c, $query); 65 $stmt = oci_parse($c, $query); 92 $s1 = oci_parse($c, $drop_1); 93 $s2 = oci_parse($c, $drop_2);
|
H A D | lob_022.phpt | 16 $statement = oci_parse($c, $drop); 20 $statement = oci_parse($c, $create); 24 $statement = oci_parse($c, $init); 34 $statement = oci_parse($c, $init); 50 $statement = oci_parse ($c, $query); 59 $statement = oci_parse ($c, $query); 68 $statement = oci_parse($c, $drop);
|
H A D | bind_sqltnum.phpt | 33 $s = oci_parse($c, "select dump($colname) from bind_sqltnum_tab where id = :id"); 45 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (100, :c2)"); 58 $s = oci_parse($c, "select id, varchar2_t10 from bind_sqltnum_tab"); 81 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (41, :c2)"); 87 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (42, :n1)"); 96 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (43, :n1)"); 105 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (44, :n1)"); 114 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (45, :n1)"); 123 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (46, :n1)"); 132 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (47, :n1)"); [all …]
|
H A D | bind_sqltnum_11g.phpt | 33 $s = oci_parse($c, "select $colname from bind_sqltnum_tab where id = :id"); 45 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (100, :c2)"); 58 $s = oci_parse($c, "select id, varchar2_t10 from bind_sqltnum_tab"); 81 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (41, :c2)"); 87 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (42, :n1)"); 96 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (43, :n1)"); 105 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (44, :n1)"); 114 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (45, :n1)"); 123 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (46, :n1)"); 132 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (47, :n1)"); [all …]
|
H A D | bug51253.phpt | 16 $statement = oci_parse($c, $drop); 20 $statement = oci_parse($c, $create); 28 $statement = oci_parse($c, $create_pkg); 51 $statement = oci_parse($c, $create_pkg_body); 55 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 66 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 77 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 87 $statement = oci_parse($c, "DROP PACKAGE BUG51253_PKG"); 89 $statement = oci_parse($c, "DROP TABLE BIND_TEST");
|
H A D | bind_sqltchr_1.phpt | 27 $s = oci_parse($c, "select $colname from bind_sqltchr_tab where id = :id"); 39 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, varchar2_t10) VALUES (241, :c2)"); 48 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (242, :n1)"); 57 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (243, :n1)"); 66 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (244, :n1)"); 75 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (245, :n1)"); 84 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (246, :n1)"); 93 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (247, :n1)"); 102 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t92) VALUES (248, :n1)"); 111 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t92) VALUES (249, :n1)"); [all …]
|
H A D | array_bind_014.phpt | 16 $statement = oci_parse($c, $drop); 20 $statement = oci_parse($c, $create); 28 $statement = oci_parse($c, $create_pkg); 48 $statement = oci_parse($c, $create_pkg_body); 52 $statement = oci_parse($c, "INSERT INTO bind_test VALUES (".$i.")"); 56 $statement = oci_parse($c, "BEGIN array_bind_014_pkg.iobind(:c1); END;");
|
H A D | lob_null.phpt | 19 $s = oci_parse($c, 'drop table lob_null_tab'); 25 $s = oci_parse($c, 32 $s = oci_parse($c, 42 $s = oci_parse($c, "insert into lob_null_tab values (1, :b)"); 56 $s = oci_parse($c, "insert into lob_null_tab values (2, :b)"); 70 $s = oci_parse($c, "insert into lob_null_tab values (3, :b)"); 86 $s = oci_parse($c, "call lob_null_proc_in(4, :b)"); 100 $s = oci_parse($c, "call lob_null_proc_in(5, :b)"); 114 $s = oci_parse($c, "call lob_null_proc_in(6, :b)"); 173 $s = oci_parse ($c, "call lob_null_proc_out($i, :b)"); [all …]
|
H A D | bind_long_raw.phpt | 15 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); 18 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); 27 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); 34 $stmt = oci_parse($c, "drop table phptestlngraw");
|
H A D | bind_raw.phpt | 15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 35 $stmt = oci_parse($c, "drop table phptestrawtable");
|
H A D | bind_raw_2.phpt | 15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 35 $stmt = oci_parse($c, "drop table phptestrawtable");
|
H A D | bind_number.phpt | 30 $s = oci_parse($c, "select $colname from bind_number_tab where id = :id"); 41 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, number_t6) VALUES (1, :n1)"); 50 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, float_t) VALUES (66, :f1)"); 59 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_float_t) VALUES (67, :f1)"); 68 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (69, :f1)"); 77 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (71, :f1)"); 86 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (72, :f1)"); 95 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (73, :f1)"); 104 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (75, :f1)"); 113 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (76, :f1)");
|
H A D | commit_001.phpt | 18 if (!($s = oci_parse($c, $insert_sql))) { 19 die("oci_parse(insert) failed!\n"); 40 if (!($select = oci_parse($c, $select_sql))) { 41 die("oci_parse(select) failed!\n"); 58 if (!($s = oci_parse($c, $insert_sql))) { 59 die("oci_parse(insert) failed!\n");
|
H A D | array_bind_011.phpt | 11 $statement = oci_parse($c, $drop); 15 $statement = oci_parse($c, $create); 23 $statement = oci_parse($c, $create_pkg); 46 $statement = oci_parse($c, $create_pkg_body); 49 $statement = oci_parse($c, "BEGIN array_bind_011_pkg.iobind(:c1); END;");
|
H A D | array_bind_float.phpt | 16 $statement = oci_parse($c, $drop); 20 $statement = oci_parse($c, $create); 28 $statement = oci_parse($c, $create_pkg); 51 $statement = oci_parse($c, $create_pkg_body); 54 $statement = oci_parse($c, "BEGIN array_bind_float_pkg.iobind(:c1); END;");
|