Re: problem with exception handling

In article <1103236627.680720.19790_at_c13g2000cwb.googlegroups.com>, ford_desperado_at_yahoo.com says...
>
>Thanks Tom,
>
>the only difference between your procedure and mine that I noticed is
>that yours is in lowercase while mine is in uppercase. Are you
>suggesting that uppercase SQL is bad programming style?
>

No, the big difference is

1. pragma autonomous_transaction;
2. commit;

(but no, I am personally not a fan of uppercase in code, I find it miserable hard to read for some reason... but that is a matter of opinion)

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation