Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> fetch across commits
On an earlier post, someone referred me to an Oracle article about
a snapshot
too old error. But the article raised another question for me. Here is
the last
paragraph of the article.
http://support.us.oracle.com/cgi-bin/cr/getpart_cr.cgi?BUL-103220.525
Summary:Fetches across commits as explained in last two cases are not
supported by ANSI standard. Accoding to ANSI standard a cursor
is invalidated when a commit is performed and should be closed and reopened. Oracle allows users to do fetch across commits but users should be aware that it might result in ORA-1555.
Oracle allows users to do fetch across commits. I thought you got a
fetch
out of sequence error when you did that?