Skip to main content
May 1, 2006
Question

fetch out of sequence

  • May 1, 2006
  • 1 reply
  • 406 views
Has anybody experienced problems with an oracle error "fetch out of sequence" in the follwing scenario:?
"select * from external linked table"
Where external table comes from a machine linked to the main database server.
This works in a cfquery but if I put it in stored procedure and then call it from Coldfusion I get the dreaded out of sequence error.

Thanks for your help
This topic has been closed for replies.

1 reply

Participating Frequently
May 1, 2006
What does your PL/SQL look like? Are you using a FOR UPDATE clause in a cursor by any chance and doing any kind of COMMIT within the cursor loop, etc.?

Phil