Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Fetch out of sequence error message
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