Fetch out of sequence error
587785Aug 22 2007 — edited Aug 23 2007Hi,
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