Annotation of embedaddon/php/ext/oci8/tests/lob_039.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: Test CLOB->write() for multiple inserts
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: require dirname(__FILE__).'/create_table.inc';
13:
14: echo "Test 1: CLOB\n";
15:
16: $ora_sql = "INSERT INTO
17: ".$schema.$table_name." (clob)
18: VALUES (empty_clob())
19: RETURNING
20: clob
21: INTO :v_clob ";
22:
23: $s = oci_parse($c,$ora_sql);
24: $clob = oci_new_descriptor($c,OCI_DTYPE_LOB);
25:
26:
27: oci_bind_by_name($s,":v_clob", $clob,-1,OCI_B_CLOB);
28:
29: oci_execute($s, OCI_DEFAULT);
30: var_dump($clob->write("clob test 1"));
31:
32: oci_execute($s, OCI_DEFAULT);
33: var_dump($clob->write("clob test 2"));
34:
35: oci_execute($s, OCI_DEFAULT);
36: var_dump($clob->write("clob test 3"));
37:
38: $s = oci_parse($c,"select clob from ".$schema.$table_name);
39: var_dump(oci_execute($s));
40:
41: oci_fetch_all($s, $res);
42:
43: var_dump($res);
44:
45:
46: require dirname(__FILE__).'/drop_table.inc';
47:
48: echo "Done\n";
49:
50: ?>
51: --EXPECT--
52: Test 1: CLOB
53: int(11)
54: int(11)
55: int(11)
56: bool(true)
57: array(1) {
58: ["CLOB"]=>
59: array(3) {
60: [0]=>
61: string(11) "clob test 1"
62: [1]=>
63: string(22) " clob test 2"
64: [2]=>
65: string(33) " clob test 3"
66: }
67: }
68: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>