http://qs1969.pair.com?node_id=502208


in reply to (OT) sqlplus rollback on error

You should also 
set autocommit off

[download]
in case some muppet has turned on autocommit in the PL/SQL defaults.

In Section Seekers of Perl Wisdom