Re: How do I prevent "commit" when a program crashes???

I suspect you are using SQL*Plus, which has a setting for the parameter <autocommit. which defaults to ALL. Change this to NO and you then need to commit explicitly whenever your program logic dictates.

AUTO[COMMIT]= Y[YES] commits every statement
AUTO[COMMIT] = A[LL] commits on exit froSQL*PLUS (the default)
AUTO[COMMIT] = N[O] commits only when you tell it to

Chrysalis.

Z. Martinez wrote:
>
> I have a Pro*C program that I am working on.
>
> Currently, I commit after every 10,000 inserts. However, I noticed
> that when I break out of the program while in execution (using
> ctrl+C), the uncommitted records are committed to the database.
>
> How do I prevent this from happening???
>
> I'm working on Oracle 7.3 under HPUX.
>
> Thanks in advance.
>
> Please respond to zlm101_at_psu.edu
Received on Wed Apr 23 1997 - 00:00:00 CDT