ID: 46565 Updated by: [EMAIL PROTECTED] Reported By: james_blond at hipernet dot brda dot net -Status: Open +Status: Assigned -Bug Type: OCI8 related +Bug Type: Feature/Change Request Operating System: * PHP Version: 5.2.6 Assigned To: sixd
Previous Comments: ------------------------------------------------------------------------ [2008-11-19 00:18:49] [EMAIL PROTECTED] The oci_fetch_all() function was designed to cancel a query after being called once. The behavior you see is expected. However it sounds like a possible enhancement. ------------------------------------------------------------------------ [2008-11-13 13:00:26] james_blond at hipernet dot brda dot net Description: ------------ function oci_fetch_all on second use return error ORA-01002: fetch out of sequence. Reproduce code: --------------- $dbstr = "(DESCRIPTION = (ADDRESS = PROTOCOL = TCP (HOST = host)(PORT = 1521))(CONNECT_DATA = (SID = sid)))"; $c = oci_connect("user","pass",$dbstr,"UTF8"); $SQL = "SELECT * FROM table "; // table have more then 100 rec $s = oci_parse($c,$SQL); oci_execute($s,OCI_COMMIT_ON_SUCCESS); oci_fetch_all($s,$Row,0,10, OCI_NUM); print_r($Row); oci_fetch_all($s,$Row,10,10, OCI_NUM);// here return error ORA-01002 print_r($Row); Expected result: ---------------- printed array $Row Actual result: -------------- array $Row is printed only on first time on second $Row is empty , oci_fetch_all -> return error ORA-01002: fetch out of sequence. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46565&edit=1