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!

Error while connecting from Oracle to DB2 through database links

CrazyAnieJan 19 2009 — edited Feb 4 2009

Hi,
I am working on a VB application wherein I am using the ORAOLEDB.Oracle driver for connecting to my Oracle 10g R2 database. My Oracle database in turn connects to a DB2 database through a database link. When I try to run stored procedures containing simple PL/SQL queries, the connection works fine and fetches all the data. However, when i try to execute a stored poc containing a reference cursor in it, I start encountering the following error message in the application:

ORA-01002: Fetch out of sequence.
Preceeding line from the <<DB link to DB2>>

Please do advice.

Thanks in advance.

This post has been answered by gdarling - oracle on Jan 30 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2009

Added on Jan 19 2009

#oracle-provider-for-ole-db, #windows-and-net

8 comments

4,002 views