Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> fetch across commits

fetch across commits

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Fri, 28 May 1999 15:17:16 -0400
Message-ID: <374EEBBC.119318CA@bigfoot.com>

     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?

Received on Fri May 28 1999 - 14:17:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US