On Wed, Sep 26, 2001 at 03:12:53PM +1200, Dan Horne wrote:
> 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
Odd.
Is that behaviour documented by Oracle?
Are you using OCI 7 or OCI 8?
Can you provide a small self-contained test case?
Tim.
