"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
news:3b7b93cc$0$233$ed9e5944_at_reading.news.pipex.net:
> CURSOR C_REMOTE IS
> <some select statement>
>
>
> FOR remote_rec in C_REMOTE LOOP
> IF i mod 1000 THEN
> <insert statement>
> COMMIT;
> ELSE
> <insert statement>
> END IF
> i:= i + 1
> END LOOP
>>
>> I'm going to pull data from a remote table, insert it into a local
>> table, and I want to perform commits
Be aware that if you commit, and fetch from an open cursor you stand the
chance to hit ORA-01555. If you really want to commit along the way. Open
and close the select cursor.
--
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com
Received on Fri Aug 17 2001 - 21:22:45 CDT
