Re: autocommit in PRO C

From: Alan Polansky <alanp_at_tibinc.com>
Date: Tue, 23 Nov 1999 16:51:11 -0500
Message-ID: <s3m328d0rrp36_at_corp.supernews.com>

Based upon my research I decided to implement a embedded PL/SQL procedure to do the deletion. The following will do a commit after each :iDeletionCommitInterval deletes are done from table log_msg_text.

        EXEC SQL EXECUTE

        begin
            loop
                DELETE FROM log_msg_text
                WHERE rownum <= :iDeletionCommitInterval AND add_date <

TO_DATE(
 :szDeleteDate, 'MM/DD/YYYY HH24:MI:SS' );

                :iLastRowCount := SQL%ROWCOUNT;
                COMMIT;

                :iTotalRowCount := :iTotalRowCount + :iLastRowCount;

                if :iLastRowCount < :iDeletionCommitInterval then
                    exit;
                end if;
            end loop;
        end;

Alan Polansky <alanp_at_tibinc.com> wrote in message news:s30pumtvhsq88_at_corp.supernews.com...
> I want to turn on autocommit in my C++ program. This program uses embedded
> SQL via PRO*C/C++. Howeverm "set autocommit on" is sqlplus, which is not
> supported in PRO C. How do I do this?
>
> I want to use this on deletion or rows.
>
>
Received on Tue Nov 23 1999 - 22:51:11 CET