xref: /PHP-8.3/ext/oci8/tests/lob_025.phpt (revision a53e5617) 
1--TEST--
2oci_lob_read() tests
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7require_once 'skipifconnectfailure.inc';
8$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
9require __DIR__.'/skipif.inc';
10?>
11--FILE--
12<?php
13
14require __DIR__.'/connect.inc';
15require __DIR__.'/create_table.inc';
16
17$ora_sql = "INSERT INTO
18                       ".$schema.$table_name." (blob)
19                      VALUES (empty_blob())
20                      RETURNING
21                               blob
22                      INTO :v_blob ";
23
24$statement = oci_parse($c,$ora_sql);
25$blob = oci_new_descriptor($c,OCI_D_LOB);
26oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB);
27oci_execute($statement, OCI_DEFAULT);
28
29var_dump($blob->size());
30var_dump($blob->write(str_repeat("string.", 1000)));
31var_dump($blob->size());
32oci_commit($c);
33
34$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
35$s = oci_parse($c, $select_sql);
36oci_execute($s, OCI_DEFAULT);
37
38var_dump($row = oci_fetch_array($s));
39
40var_dump(oci_lob_read($row[0], 2));
41var_dump(oci_lob_eof($row[0]));
42
43unset($row[0]->descriptor);
44var_dump(oci_lob_read($row[0],1));
45var_dump(oci_lob_eof($row[0]));
46
47require __DIR__.'/drop_table.inc';
48
49echo "Done\n";
50
51?>
52--EXPECTF--
53int(0)
54int(7000)
55int(7000)
56array(2) {
57  [0]=>
58  object(OCILob)#%d (1) {
59    ["descriptor"]=>
60    resource(%d) of type (oci8 descriptor)
61  }
62  ["BLOB"]=>
63  object(OCILob)#%d (1) {
64    ["descriptor"]=>
65    resource(%d) of type (oci8 descriptor)
66  }
67}
68string(2) "st"
69bool(false)
70
71Warning: oci_lob_read(): Unable to find descriptor property in %s on line %d
72bool(false)
73
74Warning: oci_lob_eof(): Unable to find descriptor property in %s on line %d
75bool(false)
76Done
77