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