1--TEST-- 2collections and nulls 3--EXTENSIONS-- 4oci8 5--SKIPIF-- 6<?php 7$target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs 8require(__DIR__.'/skipif.inc'); 9?> 10--FILE-- 11<?php 12 13require __DIR__."/connect.inc"; 14 15error_reporting(E_ALL ^ E_DEPRECATED); 16 17$ora_sql = "DROP TYPE ".$type_name; 18 19$statement = oci_parse($c,$ora_sql); 20@oci_execute($statement); 21 22$ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR(10)"; 23 24$statement = oci_parse($c,$ora_sql); 25oci_execute($statement); 26 27 28$coll1 = oci_new_collection($c, $type_name); 29$coll2 = oci_new_collection($c, $type_name); 30 31var_dump(oci_collection_append($coll1, null)); 32 33var_dump(oci_collection_assign($coll2, $coll1)); 34 35var_dump(oci_collection_element_get($coll2, 0)); 36 37echo "Done\n"; 38 39require __DIR__."/drop_type.inc"; 40 41?> 42--EXPECT-- 43bool(true) 44bool(true) 45NULL 46Done 47
