Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Fetch out of sequence error message

Fetch out of sequence error message

From: Mohammed Al-Raisi <mohd4694_at_omantel.net.om>
Date: 2000/05/22
Message-ID: <392922E2.71589683@omantel.net.om>#1/1

Hi there:
We have two databases. the 1st is Oracle 8.1.6 and the 2nd is 7.2.3. I have a PRO C program which is using the remote databse connectiong string of 'T:host:instance' to fetch a record from Oracle8.1.6 database using synonyms created in the 7.2.3 databse which are referensing tables in the 8.1.6 databse. the synonyms were created by the command: create synonym synon-name for remote-user(8.1.6).table-name_at_database-link. But once the query button is pressed, the ORA-1002 out of sequence and the ORA-2063 preceeding line from database link messages appear. Is there a way around this? or anyone can explain why this messages are coming?

PS. the tables are accessable through sql-plus using the same synonyms.

regards.

Mohammed Al-Raisi Received on Mon May 22 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US