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