Oracle 9 Rel2 & php-4.2.2

[teamshadow]

I have oracle 9 release 2 installed on a redhat linux 7.2 server connecting to a remote oracle 7.3.4 server.

oci8 functions connect to oracle, parse and execute the statement but as soon as ocifetch is called it bombs with the message
Warning: OCIFetch: ORA-01002: fetch out of sequence in /var/www/html/testoracle.php on line 15

Then if I try and call and echo OCIResult($stmt,'FIELD') I get inconsistant data, sometimes it letters, other times it was the script name.

I also compiled --with-oracle, using the same ORACLE_HOME, and the calls to ora_fetch work fine.

I checked oracle and apache has sessions connected to oracle that have sent data to and from the linux machine.

any help would be appreciated.

[steved]

Sounds like your query is failing to return any results. You need to check to see if you have any results before you fetch them.

[teamshadow]

I am running the same query as the oracle 7 functions that work. I even updated the query to return 2 results to make sure it wasn't missing one.

[chetwest]

Take a look at this...

ORA-01002 - fetch out of sequence

Cause:In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error.

Action😛arse and execute a SQL statement before attempting to fetch the data.

Chet West
http://www.Oracletricks.com

[teamshadow]

I have already looked at the oracle error codes. I am running a simple select statement, I have tried on every script the runs a SQL statement (these scripts all work on 2 other servers).

And I don't think it is Oracle since the oracle functions for PHP work when compiled with the same ORACLE_HOME.