1--TEST-- 2oci_fetch_row() 3--EXTENSIONS-- 4oci8 5--SKIPIF-- 6<?php 7require_once 'skipifconnectfailure.inc'; 8?> 9--FILE-- 10<?php 11 12require __DIR__.'/connect.inc'; 13 14// Initialize 15 16$stmtarray = array( 17 "drop table fetch_row_tab", 18 "create table fetch_row_tab (id number, value number)", 19 "insert into fetch_row_tab (id, value) values (1,1)", 20 "insert into fetch_row_tab (id, value) values (1,1)", 21 "insert into fetch_row_tab (id, value) values (1,1)", 22); 23 24oci8_test_sql_execute($c, $stmtarray); 25 26// Run Test 27 28if (!($s = oci_parse($c, "select * from fetch_row_tab"))) { 29 die("oci_parse(select) failed!\n"); 30} 31 32if (!oci_execute($s)) { 33 die("oci_execute(select) failed!\n"); 34} 35while ($row = oci_fetch_row($s)) { 36 var_dump($row); 37} 38 39// Cleanup 40 41$stmtarray = array( 42 "drop table fetch_row_tab" 43); 44 45oci8_test_sql_execute($c, $stmtarray); 46 47echo "Done\n"; 48 49?> 50--EXPECT-- 51array(2) { 52 [0]=> 53 string(1) "1" 54 [1]=> 55 string(1) "1" 56} 57array(2) { 58 [0]=> 59 string(1) "1" 60 [1]=> 61 string(1) "1" 62} 63array(2) { 64 [0]=> 65 string(1) "1" 66 [1]=> 67 string(1) "1" 68} 69Done 70