2 Bug #37706 (Test LOB locator reuse. Extends simple test of lob_037.phpt)
5 $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6 require(dirname(__FILE__).'/skipif.inc');
11 define('NUMLOBS', 200);
13 require(dirname(__FILE__).'/connect.inc');
14 require(dirname(__FILE__).'/create_table.inc');
16 for ($i = 0; $i < NUMLOBS; $i++) {
17 $s = oci_parse($c, "insert into ".$schema.$table_name." (id, clob) values(".$i.", '".$i."aaaa".$i.$i."aaaaaaaaaaaaaaaaaaaaaaaaaaaz')");
21 echo "Test 1: CLOB as locator\n";
23 $s = oci_parse($c, "select clob from ".$schema.$table_name." order by id");
27 for ($i = 0; $i < NUMLOBS; $i++) {
28 $row[$i] = oci_fetch_array($s, OCI_NUM);
31 for ($i = 0; $i < NUMLOBS; $i++) {
32 echo "Row $i Size: " . $row[$i][0]->size() . "\n";;
33 echo "Pos 1: " . $row[$i][0]->tell() . "\n";
34 echo "Data: " . $row[$i][0]->read(5) . "\n";;
35 echo "Pos 2: " . $row[$i][0]->tell() . "\n";
36 echo "Data: " . $row[$i][0]->read(12) . "\n";
43 Test 1: CLOB as locator