PHP5 PDO/Oci + Oracle7.3.4.0.1 Problem
496903Mar 8 2006 — edited Mar 21 2006I'm currently having problems accessing Oracle 7.3.4.0.1 database using the PDO or the Oci / Oci8 extensions in PHP5.1.1. Each time I connect to an Oracle7 database and do a select I get an "ORA-01002: fetch out of sequence" error. I use the same libraries/extensions to access other databases including an oracle 10g database without any problems. The problem only exists when connecting to an Oracle 7 database.
Now, I know itÂ’s not the Oracle client because I can successfully connect to the Oracle 7.3.4 database and fetch data using the old PHP4 (php_oracle.dll) ora_ functions. I have also tried inserting the environment variables in the PHP script (ORACLE_HOME, TNS_ADMIN, NLS_LANG, NLS_CHARSET, ORACLE_SID, ORA_NLS33) and still nothing works.
Has anybody else run into this problem?
Jose.