1--TEST-- 2Bug #44113 (New collection creation can fail with OCI-22303) 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'; 10if (getenv('SKIP_SLOW_TESTS')) die('skip slow tests excluded by request'); 11?> 12--FILE-- 13<?php 14 15require __DIR__.'/connect.inc'; 16 17// Initialization 18 19$stmtarray = array( 20 "create or replace type bug44113_list_t as table of number" 21); 22 23oci8_test_sql_execute($c, $stmtarray); 24 25// Run Test 26// The test can take some time to complete and can exceed PHP's test 27// timeout limit on slow networks. 28 29for ($x = 0; $x < 70000; $x++) { 30 if (!($var = oci_new_collection($c, 'BUG44113_LIST_T'))) { 31 print "Failed new collection creation on $x\n"; 32 break; 33 } 34} 35 36print "Completed $x\n"; 37 38// Cleanup 39 40$stmtarray = array( 41 "drop type bug44113_list_t" 42); 43 44oci8_test_sql_execute($c, $stmtarray); 45 46echo "Done\n"; 47 48?> 49--EXPECT-- 50Completed 70000 51Done 52
