This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Dear colleages, i am getting this exception randomly when i am calling procedure from jsp page java.sql.SQLException RA-01002:fetch out of sequence this error is coming randomly when this error has occured i am not getting data from database i am willing to know the problem is it from jsp or database procedure
In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error.