Annotation of embedaddon/php/ext/oci8/tests/coll_019.phpt, revision 1.1.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>