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