release/src/router/php/ext/oci8/tests/coll_015_func.phpt

   1 --TEST--
   2 collections and numbers (2)
   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 $ora_sql = "DROP TYPE
  14                                                 ".$type_name."
  15                    ";
  16
  17 $statement = OCIParse($c,$ora_sql);
  18 @OCIExecute($statement);
  19
  20 $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER";
  21
  22 $statement = OCIParse($c,$ora_sql);
  23 OCIExecute($statement);
  24
  25
  26 $coll1 = ocinewcollection($c, $type_name);
  27
  28 var_dump(oci_collection_append($coll1, 1));
  29 var_dump(oci_collection_element_assign($coll1,0,2345));
  30 var_dump(oci_collection_element_get($coll1, 0));
  31
  32 echo "Done\n";
  33
  34 require dirname(__FILE__)."/drop_type.inc";
  35
  36 ?>
  37 --EXPECT--
  38 bool(true)
  39 bool(true)
  40 float(2345)
  41 Done