Return to bug35973.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Bug #35973 (Error ORA-24806 occurs when trying to fetch a NCLOB field)
                      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: $s1 = oci_parse($c, "drop table test_nclob");
                     14: @oci_execute($s1);
                     15: 
                     16: $s2 = oci_parse($c, "create table test_nclob (nc NCLOB)");
                     17: oci_execute($s2);
                     18: 
                     19: $s3 = oci_parse($c, "insert into test_nclob (nc) values ('12345data')");
                     20: oci_execute($s3);
                     21: 
                     22: $s3 = oci_parse($c, "select * from test_nclob");
                     23: oci_execute($s3);
                     24: 
                     25: var_dump($data = oci_fetch_assoc($s3));
                     26: $d = $data['NC'];
                     27: 
                     28: var_dump($d->read(5));
                     29: var_dump($d->read(4));
                     30: 
                     31: $s1 = oci_parse($c, "drop table test_nclob");
                     32: @oci_execute($s1);
                     33: 
                     34: echo "Done\n";
                     35: ?>
                     36: --EXPECTF--    
                     37: array(1) {
                     38:   ["NC"]=>
                     39:   object(OCI-Lob)#%d (1) {
                     40:     ["descriptor"]=>
                     41:     resource(%d) of type (oci8 descriptor)
                     42:   }
                     43: }
                     44: string(%d) "%s5"
                     45: string(%d) "%sa"
                     46: Done