Return to lob_018.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/lob_018.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: fetching the same lob several times
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10:        
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: // Initialization
                     14: 
                     15: $stmtarray = array(
                     16:        "drop table lob_018_tab",
                     17:        "create table lob_018_tab (mykey number, lob_1 clob)",
                     18: );
                     19: 
                     20: oci8_test_sql_execute($c, $stmtarray);
                     21: 
                     22: echo "Test 1\n";
                     23: 
                     24: $init = "insert into lob_018_tab (mykey, lob_1) values(1, empty_clob()) returning lob_1 into :mylob";
                     25: $statement = oci_parse($c, $init);
                     26: $clob = oci_new_descriptor($c, OCI_D_LOB);
                     27: oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB);
                     28: oci_execute($statement, OCI_DEFAULT);
                     29: $clob->save("data");
                     30: 
                     31: oci_commit($c);
                     32: 
                     33: $init = "insert into lob_018_tab (mykey, lob_1) values(2, empty_clob()) returning lob_1 into :mylob";
                     34: $statement = oci_parse($c, $init);
                     35: $clob = oci_new_descriptor($c, OCI_D_LOB);
                     36: oci_bind_by_name($statement, ":mylob", $clob, -1, OCI_B_CLOB);
                     37: oci_execute($statement, OCI_DEFAULT);
                     38: $clob->save("long data");
                     39: 
                     40: oci_commit($c);
                     41: 
                     42: 
                     43: $query = 'select * from lob_018_tab order by mykey asc';
                     44: $statement = oci_parse ($c, $query);
                     45: oci_execute($statement, OCI_DEFAULT);
                     46: 
                     47: while ($row = oci_fetch_array($statement, OCI_ASSOC)) {
                     48:        $result = $row['LOB_1']->load();
                     49:        var_dump($result);
                     50: }
                     51: 
                     52: echo "Test 2\n";
                     53: 
                     54: $query = 'select * from lob_018_tab order by mykey desc';
                     55: $statement = oci_parse ($c, $query);
                     56: oci_execute($statement, OCI_DEFAULT);
                     57: 
                     58: while ($row = oci_fetch_array($statement, OCI_ASSOC)) {
                     59:        $result = $row['LOB_1']->load();
                     60:        var_dump($result);
                     61: }
                     62: 
                     63: echo "Test 3 - bind with SQLT_CLOB (an alias for OCI_B_CLOB)\n";
                     64: 
                     65: $init = "insert into lob_018_tab (mykey, lob_1) values(3, empty_clob()) returning lob_1 into :mylob";
                     66: $statement = oci_parse($c, $init);
                     67: $clob = oci_new_descriptor($c, OCI_D_LOB);
                     68: oci_bind_by_name($statement, ":mylob", $clob, -1, SQLT_CLOB);
                     69: oci_execute($statement, OCI_DEFAULT);
                     70: $clob->save("more stuff");
                     71: 
                     72: oci_commit($c);
                     73: 
                     74: $query = 'select * from lob_018_tab where mykey = 3';
                     75: $statement = oci_parse ($c, $query);
                     76: oci_execute($statement, OCI_DEFAULT);
                     77: 
                     78: while ($row = oci_fetch_array($statement, OCI_ASSOC)) {
                     79:        $result = $row['LOB_1']->load();
                     80:        var_dump($result);
                     81: }
                     82: 
                     83: // Cleanup
                     84: 
                     85: $stmtarray = array(
                     86:     "drop table lob_018_tab"
                     87: );
                     88: 
                     89: oci8_test_sql_execute($c, $stmtarray);
                     90: 
                     91: ?>
                     92: ===DONE===
                     93: <?php exit(0); ?>
                     94: --EXPECTF--
                     95: Test 1
                     96: string(4) "data"
                     97: string(9) "long data"
                     98: Test 2
                     99: string(9) "long data"
                    100: string(4) "data"
                    101: Test 3 - bind with SQLT_CLOB (an alias for OCI_B_CLOB)
                    102: string(10) "more stuff"
                    103: ===DONE===