Annotation of embedaddon/php/ext/oci8/tests/define_old.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: ocidefinebyname()
3: --SKIPIF--
4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5: --FILE--
6: <?php
7:
8: require(dirname(__FILE__)."/connect.inc");
9:
10: // Initialize
11:
12: $stmtarray = array(
13: "drop table define_old_tab",
14: "create table define_old_tab (string varchar(10))",
15: "insert into define_old_tab (string) values ('some')",
16: );
17:
18: oci8_test_sql_execute($c, $stmtarray);
19:
20: // Run test
21:
22: $stmt = ociparse($c, "select string from define_old_tab");
23:
24: /* the define MUST be done BEFORE ociexecute! */
25:
26: $string = '';
27: ocidefinebyname($stmt, "STRING", $string, 20);
28:
29: ociexecute($stmt);
30:
31: while (ocifetch($stmt)) {
32: var_dump($string);
33: }
34:
35: // Cleanup
36:
37: $stmtarray = array(
38: "drop table define_old_tab"
39: );
40:
41: oci8_test_sql_execute($c, $stmtarray);
42:
43: echo "Done\n";
44:
45: ?>
46: --EXPECTF--
47: %unicode|string%(4) "some"
48: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>