I'm attempting to work on a little oracle search...
My problem is that if I put the OCIExecute BEFORE the OCIFetchStatement
line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of
sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute AFTER the
OCIFetchStatement I get a different error (Warning: OCIFetchStatement:
ORA-24338: statement handle not executed in ).
In this order:
OCIExecute ( $stmt_search , OCI_DEFAULT );
$nrows = OCIFetchStatement( $stmt_search , $results );
echo "<P>There are $nrows records containing your criteria.</P>";
I get the number of records, but the I don't get the reords listed.
In this order:
$nrows = OCIFetchStatement( $stmt_search , $results );
echo "<P>There are $nrows records containing your criteria.</P>";
OCIExecute ( $stmt_search , OCI_DEFAULT );
I get the list of records, but no amount of records... I tried running a
reset( $results); on it but that didn't seem to help...
Can someone help? Oracle 8.1.6 client (7.3.4 server) NT4 IIS4 PHP 4.0.4 CGI
Thanks,
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aut insanit homo, aut versus facit
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
