| Author |
Message
|
| kotagiriaashish |
 Posted: Thu Jun 18, 2015 4:26 am Post subject: ORA-01002: fetch out of sequence |
 |
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
we are getting ORA-01002: fetch out of sequence on a oracle stored procedure call, user trace shows that there is exception while calling the stored procedure....
did anyone come across this problem, if yes kindly share the solution.
this failure happens specifically for one call rest of the calls are going fine we are able to fetch data, but this one particular call with some specific values returns this exception.
 |
|
| Back to top |
|
 |
| nelson |
| Posted: Thu Jun 18, 2015 4:49 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| What happens if you call the stored procedure outside IIB with that specific values? |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Thu Jun 18, 2015 4:51 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| nelson wrote: |
| What happens if you call the stored procedure outside IIB with that specific values? |
it returns values, DB tam is able to see the cursors in their toolkit. |
|
| Back to top |
|
|
| nelson |
| Posted: Thu Jun 18, 2015 5:09 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| Well, I guess this has something to do with the data source configuration. I recommend you to check the cursor properties... Some cursor options are not enabled by default... |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Thu Jun 18, 2015 5:18 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| nelson wrote: |
| Well, I guess this has something to do with the data source configuration. I recommend you to check the cursor properties... Some cursor options are not enabled by default... |
Thaks for the advice, can you please point to any web page that contains these options, I have very little knowledge regarding the cursor properties, my searches are not showing me these options anywhere.
it would be a great help. |
|
| Back to top |
|
|
| nelson |
| Posted: Thu Jun 18, 2015 5:50 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Mon Jun 22, 2015 9:17 pm Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
I have tried all the combinations with workarounds and with EnableStaticCursorsForLongData as 0 and 1 but this exception still exists. how to know whats causing the exception.
even the UserTrace fails with a blank exception like 'Exception occured while invoking stored procedure'
where else to look for the cause of this exception? please suggest.
most of the calls are successful but only selected few fail. |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Tue Jun 23, 2015 12:41 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
This is solved..... 
So it turns out the DB team did an insert before opening a cursor and forgot to commit it. once the commit was executed everything was working fine.
Thanks for the help Nelson! |
|
| Back to top |
|
|
| nelson |
| Posted: Tue Jun 23, 2015 4:01 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| Good to know! Thanks for sharing. |
|
| Back to top |
|
|
|
|
