/PHP-8.0/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 | 18 $s1 = oci_parse($c, $drop_1); 19 $s2 = oci_parse($c, $drop_2); 23 $s1 = oci_parse($c, $create_1); 24 $s2 = oci_parse($c, $create_2); 30 $s = oci_parse($c, $insert); 36 $s = oci_parse($c, $insert); 48 $sth = oci_parse($c, $query); 58 $s1 = oci_parse($c, $drop_1); 59 $s2 = oci_parse($c, $drop_2);
|
H A D | pecl_bug8816.phpt | 18 $s1 = oci_parse($c, $drop_1); 19 $s2 = oci_parse($c, $drop_2); 23 $s1 = oci_parse($c, $create_1); 24 $s2 = oci_parse($c, $create_2); 34 $s = oci_parse($c, $insert); 40 $s = oci_parse($c, $insert); 55 $sth = oci_parse($c, $query); 62 $s1 = oci_parse($c, $drop_1); 63 $s2 = oci_parse($c, $drop_2);
|
H A D | bind_long.phpt | 13 $stmt = oci_parse($c, "drop table phptestlng"); 16 $stmt = oci_parse($c, "create table phptestlng( id number(10), filetxt long)"); 21 $stmt = oci_parse ($c, "insert into phptestlng (id, filetxt) values (:id, :filetxt)"); 31 $stmt = oci_parse($c, "SELECT filetxt FROM phptestlng where id = 1"); 40 $stmt = oci_parse ($c, "insert into phptestlng (id, filetxt) values (:id, :filetxt)"); 49 $stmt = oci_parse($c, "SELECT filetxt FROM phptestlng where id = 2"); 56 $stmt = oci_parse($c, "drop table phptestlng");
|
H A D | lob_029.phpt | 30 $s = oci_parse($c, "drop table FileTest"); 33 $s = oci_parse($c, "drop directory TestDir"); 36 $s = oci_parse($c, "create directory TestDir as '$realdirname'"); 43 $s = oci_parse($c, "create table FileTest (FileNum number, FileDesc varchar2(30), Image bfile)"); 46 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (1, 'Description 1', bfi… 49 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (2, 'Description 2', bfi… 52 $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (3, 'Description 3', bfi… 59 $s = oci_parse($c, "select count(*) numrows from FileTest"); 65 $s = oci_parse($c, "select * from FileTest order by FileNum"); 84 $s = oci_parse($c, "drop table FileTest"); [all …]
|
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 | bug35973.phpt | 13 $s1 = oci_parse($c, "drop table test_nclob"); 16 $s2 = oci_parse($c, "create table test_nclob (nc NCLOB)"); 19 $s3 = oci_parse($c, "insert into test_nclob (nc) values ('12345data')"); 22 $s3 = oci_parse($c, "select * from test_nclob"); 31 $s1 = oci_parse($c, "drop table test_nclob");
|
H A D | lob_016.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 22 $statement = oci_parse($c, $init); 26 $statement = oci_parse($c, $select); 39 $statement = oci_parse($c, $select); 49 $statement = oci_parse($c, $drop);
|
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_017.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 | lob_022.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 22 $statement = oci_parse($c, $init); 32 $statement = oci_parse($c, $init); 48 $statement = oci_parse ($c, $query); 57 $statement = oci_parse ($c, $query); 66 $statement = oci_parse($c, $drop);
|
H A D | bug40415.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); 47 $stmt = oci_parse($c, $query); 63 $stmt = oci_parse($c, $query); 90 $s1 = oci_parse($c, $drop_1); 91 $s2 = oci_parse($c, $drop_2);
|
H A D | bug51253.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 26 $statement = oci_parse($c, $create_pkg); 49 $statement = oci_parse($c, $create_pkg_body); 53 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 64 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 75 $statement = oci_parse($c, "BEGIN bug51253_pkg.iobind(:c1); END;"); 85 $statement = oci_parse($c, "DROP PACKAGE BUG51253_PKG"); 87 $statement = oci_parse($c, "DROP TABLE BIND_TEST");
|
H A D | bind_sqltnum.phpt | 32 $s = oci_parse($c, "select dump($colname) from bind_sqltnum_tab where id = :id"); 44 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (100, :c2)"); 57 $s = oci_parse($c, "select id, varchar2_t10 from bind_sqltnum_tab"); 86 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (42, :n1)"); 95 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (43, :n1)"); 104 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (44, :n1)"); 113 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (45, :n1)"); 122 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (46, :n1)"); 131 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (47, :n1)"); 140 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t92) VALUES (48, :n1)"); [all …]
|
H A D | bind_sqltnum_11g.phpt | 32 $s = oci_parse($c, "select $colname from bind_sqltnum_tab where id = :id"); 44 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (100, :c2)"); 57 $s = oci_parse($c, "select id, varchar2_t10 from bind_sqltnum_tab"); 86 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (42, :n1)"); 95 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (43, :n1)"); 104 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (44, :n1)"); 113 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (45, :n1)"); 122 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (46, :n1)"); 131 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (47, :n1)"); 140 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t92) VALUES (48, :n1)"); [all …]
|
H A D | array_bind_014.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 26 $statement = oci_parse($c, $create_pkg); 46 $statement = oci_parse($c, $create_pkg_body); 50 $statement = oci_parse($c, "INSERT INTO bind_test VALUES (".$i.")"); 54 $statement = oci_parse($c, "BEGIN array_bind_014_pkg.iobind(:c1); END;");
|
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 | bind_long_raw.phpt | 13 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); 16 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); 25 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); 32 $stmt = oci_parse($c, "drop table phptestlngraw");
|
H A D | bind_raw.phpt | 13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 33 $stmt = oci_parse($c, "drop table phptestrawtable");
|
H A D | bind_raw_2.phpt | 13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 33 $stmt = oci_parse($c, "drop table phptestrawtable");
|
H A D | lob_null.phpt | 15 $s = oci_parse($c, 'drop table lob_null_tab'); 21 $s = oci_parse($c, 28 $s = oci_parse($c, 38 $s = oci_parse($c, "insert into lob_null_tab values (1, :b)"); 52 $s = oci_parse($c, "insert into lob_null_tab values (2, :b)"); 66 $s = oci_parse($c, "insert into lob_null_tab values (3, :b)"); 82 $s = oci_parse($c, "call lob_null_proc_in(4, :b)"); 96 $s = oci_parse($c, "call lob_null_proc_in(5, :b)"); 110 $s = oci_parse($c, "call lob_null_proc_in(6, :b)"); 169 $s = oci_parse ($c, "call lob_null_proc_out($i, :b)"); [all …]
|
H A D | bind_number.phpt | 32 $s = oci_parse($c, "select $colname from bind_number_tab where id = :id"); 43 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, number_t6) VALUES (1, :n1)"); 52 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, float_t) VALUES (66, :f1)"); 61 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_float_t) VALUES (67, :f1)"); 70 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (69, :f1)"); 79 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (71, :f1)"); 88 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (72, :f1)"); 97 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (73, :f1)"); 106 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (75, :f1)"); 115 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (76, :f1)");
|
H A D | commit_001.phpt | 16 if (!($s = oci_parse($c, $insert_sql))) { 17 die("oci_parse(insert) failed!\n"); 38 if (!($select = oci_parse($c, $select_sql))) { 39 die("oci_parse(select) failed!\n"); 56 if (!($s = oci_parse($c, $insert_sql))) { 57 die("oci_parse(insert) failed!\n");
|
H A D | array_bind_005.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 26 $statement = oci_parse($c, $create_pkg); 49 $statement = oci_parse($c, $create_pkg_body); 52 $statement = oci_parse($c, "BEGIN array_bind_005_pkg.iobind(:c1); END;");
|
H A D | array_bind_006.phpt | 14 $statement = oci_parse($c, $drop); 18 $statement = oci_parse($c, $create); 26 $statement = oci_parse($c, $create_pkg); 49 $statement = oci_parse($c, $create_pkg_body); 52 $statement = oci_parse($c, "BEGIN array_bind_006_pkg.iobind(:c1); END;");
|