Skip to Main Content

SQL & PL/SQL

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!

Fetch out of sequence error

587785Aug 22 2007 — edited Aug 23 2007
Hi,
In my stored procedure I have a select statement like the below
Create procedure testDBLink
cur OUT Sys_RefCursor
AS
Begin
Select * from TABLE@DBLINK;
End

Now I am trying to call the procedure from .NET application then I am getting this error.
ORA-01002: fetch out of sequence.
Idid some googling I found that when using Commit in Procedure then we get this type of error, but in my procedure iam not using any commit. or I need to set the AutoCommitt OFF.
If I am caling the just only the Select * from Table@DBLINK from .Net application then I am not getting any error.
If I put that select statement in Procedure then I am getting Fetch out of Sequence error.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2007
Added on Aug 22 2007
10 comments
1,044 views