Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PHP5 PDO/Oci + Oracle7.3.4.0.1 Problem

496903Mar 8 2006 — edited Mar 21 2006
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2006
Added on Mar 8 2006
1 comment
993 views