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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Open cursor on data inserted within the same transaction

Re: Open cursor on data inserted within the same transaction

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Aug 2005 10:24:53 -0700
Message-ID: <1124904293.553747.276960@g47g2000cwa.googlegroups.com>


If the select criteria is correct the cursor should see the data just committed. In fact even without the commit your session should be able to see the just inserted data. I have to believe that your select somehow filters out the data in question.

Please post an example that demonstrates your problem.

HTH -- Mark D Powell -- Received on Wed Aug 24 2005 - 12:24:53 CDT

Original text of this message

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