Re: No output rows on select to ORACLE from PHP

I believe you can circumvent this error message by simply placing an @ infront of the command that is complaining. @ora_fetch(...) "Salvador Ramirez" <sram@profc.udec.CL> wrote in message news:Pine.LNX.4.21.0011112005390.1016-100000@karonte.profc.udec.CL... > Hi everybody, > > I'm using php4 to connect to an oracle8i database. I'm using the > ora_* functions instead of the oci_* functions for simplicity of > the script that should also connect to an oracle7 database. I hope > this not be the problem. > Well, all works fine, the connection, the parse of a SQL statement > and the fetch of rows from a cursor when there are rows selected > from the result of the execution of the SQL statement. However when > there is no rows on the cursor, then the ora_fetch returns FALSE > (which is OK) and also displays a warning message like this: > > Warning: Ora_Fetch failed (ORA-01722: invalid number -- while processing > OCI function OFETCH/OFEN) in /usr/local/htdocs/revisa.php on line 32 > > and the ora_error() function show the following: > > Error while trying to retrieve text for error ORA-00000 > > I wonder what could be this problem and how can I solve it? it's > ugly to show the users those messages, is there a way to avoid > the printing of any warning message in PHP? > > Thanks in advance, > > ---sram > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >