xref: /PHP-8.1/ext/oci8/tests/lob_016.phpt (revision b5a14e6c)
1--TEST--
2returning multiple lobs
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
8require(__DIR__.'/skipif.inc');
9?>
10--FILE--
11<?php
12
13require __DIR__.'/connect.inc';
14
15$drop = "DROP table lob_test";
16$statement = oci_parse($c, $drop);
17@oci_execute($statement);
18
19$create = "CREATE table lob_test(lob_1 BLOB, lob_2 BLOB)";
20$statement = oci_parse($c, $create);
21oci_execute($statement);
22
23$init = "INSERT INTO lob_test VALUES(EMPTY_BLOB(), EMPTY_BLOB())";
24$statement = oci_parse($c, $init);
25oci_execute($statement);
26
27$select = "SELECT * FROM lob_test FOR UPDATE";
28$statement = oci_parse($c, $select);
29oci_execute($statement, OCI_DEFAULT);
30
31$row = oci_fetch_assoc($statement);
32
33$row['LOB_1']->write("first");
34$row['LOB_2']->write("second");
35
36unset($row);
37
38oci_commit($c);
39
40$select = "SELECT * FROM lob_test FOR UPDATE";
41$statement = oci_parse($c, $select);
42oci_execute($statement, OCI_DEFAULT);
43
44$row = oci_fetch_assoc($statement);
45
46var_dump($row);
47var_dump($row['LOB_1']->load());
48var_dump($row['LOB_2']->load());
49
50$drop = "DROP table lob_test";
51$statement = oci_parse($c, $drop);
52@oci_execute($statement);
53
54echo "Done\n";
55
56?>
57--EXPECTF--
58array(2) {
59  ["LOB_1"]=>
60  object(OCILob)#%d (1) {
61    ["descriptor"]=>
62    resource(%d) of type (oci8 descriptor)
63  }
64  ["LOB_2"]=>
65  object(OCILob)#%d (1) {
66    ["descriptor"]=>
67    resource(%d) of type (oci8 descriptor)
68  }
69}
70string(5) "first"
71string(6) "second"
72Done
73