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 -> Cursors and transactions

Cursors and transactions

From: Andrea <A.Savino_at_agora.stm.it>
Date: 1997/01/24
Message-ID: <01bc0a01$71292c20$LocalHost@armada-savand>#1/1

Sorry for my english,
Some one can help me about this PL-Sql function.

I would like know if a write this :

....
CURSOR c_test IS
 SELECT id, errore
  FROM messagges;

.....
INSERT INTO messages VALUES (100, 'error 1'); ....
INSERT INTO messages VALUES (101, 'error 2'); ...
<< some others statments>>
...
OPEN c_test;
ROLLBACK;
->> here I see again my rows ? Is it possibile to a do a loop on that
cursor o
the rollback delete also in memory my rows ?

Thanks

-- 
Andrea
A.Savino_at_stm.it
Received on Fri Jan 24 1997 - 00:00:00 CST

Original text of this message

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