Issuing Selects from PHP Using DG4ODBC Does Not Give Correct Results And Error - Ora-1002

(Doc ID 753321.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
Checked for currency on 05-Feb-2013


Symptoms

A Database Gateway for ODBC (DG4ODBC) connection to SQL*Server has been successfully created and selects run from SQLPLUS give the correct results.
However, running the same the select in a PHP procedure does not give the correct results. Tracing from PHP shows an error -

Warning: oci_fetch_row() [function.oci-fetch-row]: ORA-01002: fetch out of sequence ORA-02063:
preceding line from DBLINK in E:\php_dir\test_script.php on line 27

PHP is a  scripting language that can be used for Web development.


.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms