Re: trying to understand transaction control in pl/sql

Manfred Peter wrote:

> Hello Ken,
>
> when you start a dml like insert, update or delete, the transaction will
> be opened (After connecting to a database).
> If you want to commit the current transaction, the type commit.
>
> begin
> insert into a values(1);
> insert into a values(2);
> insert into a values('a');
>
> COMMIT;
> end;
>
> But this is not a good programing style as somebody could call your
> procedure or function and the
> caller can not decide wether to commit the transaction or to rollback it.

Your advice confuses me completely. Do you understand Oracle architecture?

Of what possible relevance is there to another session executing any code anywhere in the database?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)