Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Cursors and transactions
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.itReceived on Fri Jan 24 1997 - 00:00:00 CST