Cursors and transactions

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


Sorry for my english,
[Quoted] [Quoted] 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 CET

Original text of this message