xref: /PHP-8.3/ext/oci8/tests/lob_036.phpt (revision a53e5617)
1--TEST--
2Exercise cleanup code when LOB buffering is on
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$s = oci_parse($c,$ora_sql);
25$blob = oci_new_descriptor($c,OCI_DTYPE_LOB);
26
27
28oci_bind_by_name($s,":v_blob", $blob,-1,OCI_B_BLOB);
29oci_execute($s, OCI_DEFAULT);
30
31var_dump($blob->write("test"));
32var_dump($blob->setBuffering(true));
33var_dump($blob->write("test"));
34
35$blob = null;
36
37require __DIR__.'/drop_table.inc';
38
39echo "Done\n";
40
41?>
42--EXPECT--
43int(4)
44bool(true)
45int(4)
46Done
47