Re: if I call a plsql is there a commit?

HansF wrote:

> if you use SQLPLus, by default there is a commit just before you leave the
> environment.

Ouch! This requires a caveat.

Provided you leave SQL*Plus cleanly and that nothing in your setup changes its default AUTOCOMMIT setting. That is a big caveat and will likely lead many to make mistakes or use bad practices.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)