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 -> Open cursor on data inserted within the same transaction

Open cursor on data inserted within the same transaction

From: NoClue <paul_rgill_at_hotmail.com>
Date: 24 Aug 2005 08:47:01 -0700
Message-ID: <1124898421.011878.27690@g47g2000cwa.googlegroups.com>

  1. I begin a transaction
  2. I insert data into a table
  3. Commit.
  4. I open a cursor to select the data i just inserted.
  5. End the transaction

The problem is that the cursor i open to select the data is not seeing the data i have previously inserted. Can anyone tell me why? Received on Wed Aug 24 2005 - 10:47:01 CDT

Original text of this message

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