5 $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6 require(dirname(__FILE__).'/skipif.inc');
11 require dirname(__FILE__)."/connect.inc";
12 require dirname(__FILE__).'/create_table.inc';
14 $insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)";
16 if (!($s = oci_parse($c, $insert_sql))) {
17 die("oci_parse(insert) failed!\n");
20 for ($i = 0; $i<3; $i++) {
21 if (!oci_execute($s)) {
22 die("oci_execute(insert) failed!\n");
26 if (!oci_commit($c)) {
27 die("oci_commit() failed!\n");
32 $select_sql = "SELECT * FROM ".$schema."".$table_name."";
34 if (!($s = oci_parse($c, $select_sql))) {
35 die("oci_parse(select) failed!\n");
38 if (!oci_execute($s)) {
39 die("oci_execute(select) failed!\n");
41 while ($row = oci_fetch_array($s)) {
47 if (!oci_execute($s)) {
48 die("oci_execute(select) failed!\n");
50 while ($row = oci_fetch_array($s, OCI_NUM)) {
56 if (!oci_execute($s)) {
57 die("oci_execute(select) failed!\n");
59 while ($row = oci_fetch_array($s, OCI_ASSOC)) {
65 if (!oci_execute($s)) {
66 die("oci_execute(select) failed!\n");
68 while ($row = oci_fetch_array($s, OCI_BOTH)) {
74 if (!oci_execute($s)) {
75 die("oci_execute(select) failed!\n");
77 while ($row = oci_fetch_array($s, OCI_RETURN_LOBS)) {
83 if (!oci_execute($s)) {
84 die("oci_execute(select) failed!\n");
86 while ($row = oci_fetch_array($s, OCI_RETURN_NULLS)) {
92 if (!oci_execute($s)) {
93 die("oci_execute(select) failed!\n");
95 while ($row = oci_fetch_array($s, OCI_NUM+OCI_RETURN_NULLS)) {
99 require dirname(__FILE__).'/drop_table.inc';