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
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.itReceived on Fri Jan 24 1997 - 00:00:00 CET