Hi all
I don't know if this has been discussed on this list before, but I just
thought I'd mention it as it took me a while to figure out why my code
wasn't working. If you call an Oracle supplied package that requires a
commit after being called (such as dbms_alert), Autocommit will not take
care of it for you - I guess because it's not a DML statement. To save you
having to type commit after all of your other SQL, create a separate
connection for the procedure calls, and commit on that handle
Dan
The Electronic Connection
PO Box 6956
Wellesley St
Auckland
www.econnection.co.nz
Ph +64 9 3072440
Fax +64 8 3264151
Mob +64 21 671731
