psql commit

I would like to know when exactly the implied commit takes place in a plsql block.

for example:

BEGIN    if flag is 'Y'
     update table a set ......
   end if

   send email to someone yada, yada...
   do some html stuff...

END I'm wondering if I can be sure the commit takes without explicitly coding it if something goes wrong after the sql part but before the END. Received on Thu Mar 02 2006 - 14:27:58 CST