Annotation of embedaddon/php/ext/oci8/tests/coll_019.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: Test collection Oracle error handling 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: $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
! 9: require(dirname(__FILE__).'/skipif.inc');
! 10: ?>
! 11: --FILE--
! 12: <?php
! 13:
! 14: require dirname(__FILE__)."/connect.inc";
! 15:
! 16: $ora_sql = "DROP TYPE ".$type_name;;
! 17: $statement = oci_parse($c,$ora_sql);
! 18: @oci_execute($statement);
! 19:
! 20:
! 21: echo "Test 0\n";
! 22: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF BLOB";
! 23: $statement = oci_parse($c,$ora_sql);
! 24: oci_execute($statement);
! 25:
! 26: $coll1 = oci_new_collection($c, $type_name);
! 27:
! 28: var_dump($coll1->append('a long string')); // invalid type for append
! 29: var_dump($coll1->assignElem(1, 'a long string')); // invalid type for assignelem()
! 30: var_dump($coll1->getElem(0));
! 31:
! 32: require dirname(__FILE__)."/drop_type.inc";
! 33:
! 34: echo "Test 1\n";
! 35: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER";
! 36: $statement = oci_parse($c,$ora_sql);
! 37: oci_execute($statement);
! 38:
! 39: $coll1 = oci_new_collection($c, $type_name);
! 40:
! 41: var_dump($coll1->assignElem(1, null)); // invalid location for null
! 42: var_dump($coll1->getElem(0));
! 43:
! 44: echo "Test 2\n";
! 45: var_dump($coll1->assignElem(1, 1234)); // invalid location for number
! 46: var_dump($coll1->getElem(0));
! 47:
! 48: require dirname(__FILE__)."/drop_type.inc";
! 49:
! 50: echo "Test 3\n";
! 51: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR2(1)";
! 52: $statement = oci_parse($c,$ora_sql);
! 53: oci_execute($statement);
! 54:
! 55: $coll1 = oci_new_collection($c, $type_name);
! 56:
! 57: var_dump($coll1->assignElem(1, 'abc')); // invalid location for string
! 58: var_dump($coll1->getElem(0));
! 59:
! 60: require dirname(__FILE__)."/drop_type.inc";
! 61:
! 62: echo "Test 4\n";
! 63: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE";
! 64: $statement = oci_parse($c,$ora_sql);
! 65: oci_execute($statement);
! 66:
! 67: $coll1 = oci_new_collection($c, $type_name);
! 68:
! 69: var_dump($coll1->append(1)); // invalid date format
! 70: var_dump($coll1->assignElem(1, '01-JAN-06')); // invalid location for date
! 71: var_dump($coll1->getElem(0));
! 72:
! 73: require dirname(__FILE__)."/drop_type.inc";
! 74:
! 75: echo "Done\n";
! 76:
! 77: ?>
! 78: --EXPECTF--
! 79: Test 0
! 80:
! 81: Notice: OCI-Collection::append(): Unknown or unsupported type of element: 113 in %s on line %d
! 82: bool(false)
! 83:
! 84: Notice: OCI-Collection::assignelem(): Unknown or unsupported type of element: 113 in %s on line %d
! 85: bool(false)
! 86: bool(false)
! 87: Test 1
! 88:
! 89: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
! 90: bool(false)
! 91: bool(false)
! 92: Test 2
! 93:
! 94: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
! 95: bool(false)
! 96: bool(false)
! 97: Test 3
! 98:
! 99: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
! 100: bool(false)
! 101: bool(false)
! 102: Test 4
! 103:
! 104: Warning: OCI-Collection::append(): OCI-01840: input value not long enough for date format in %s on line %d
! 105: bool(false)
! 106:
! 107: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
! 108: bool(false)
! 109: bool(false)
! 110: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>