Re: SQL*Plus: ROLLBACK and Rowtype values

A copy of this was sent to "Henk Hultink" <hhu_at_stopspam.stoas.nl> (if that email address didn't require changing) On Wed, 23 May 2001 18:05:18 +0200, you wrote:

>Hi,
>
>Does anyone know whether a ROLLBACK in PL/SQL also deletes values in a
>Rowtype variable. An INSERT is failing, but we can't figure out why. Except
>that one of the NOT NULL columns is supposed to be filled with the value of
>a field from a ROWTYPE variable, immediately after a ROLLBACK has been
>issued.
>TIA
a rollback will NOT affect the status or value of any PLSQL variables. A rollback affects database changes only.

The rollback is not affecting a plsql "rowtype" defined variable.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp