Re: pl/sql - auto commit

Nandakumar пишет в сообщении <7pvbs9$p22$1_at_nnrp1.deja.com> ...
>Do pl/sql sub programs 'COMMIT' for any INSERT/UPDATE operations handled
>inside, on successful exit?

Not
On default commit DON'T execute on successful exit Autocommit - execute commit if record-pointer relocate to other record

If you call Stored Procedure over BDE - commit execute on successful exit stored procedure and execute rollback on exception - it is known bag BDE Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Certified Oracle DBA on www.tekmetrics.com/transcript.shtml?pid=13518 Alex_Romanov_at_mail.ru
ICQ 6220754 Received on Wed Aug 25 1999 - 08:03:15 CDT