Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to rollback the inserts done by SQL Loader

513417Dec 17 2007 — edited Dec 19 2007

Hi,
I am loading few records through sqlloader.
After insertion of these records, I have to join this table with other table and look for some conditions.

If these conditions don't match then I have to rollback the inserts done by Sql Loader.

It seems SQL Loader fires autonomous COMMIT. So I am not able to rollback.

Is there any way to achieve this?

Thanks & Regards,

Avinash.
Pune.
India.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2008

Added on Dec 17 2007

#forms, #moved-from-devops

3 comments

3,590 views