Skip to Main Content

SQL & PL/SQL

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 can i do rollback by inserting into table in postgresql via db link.

AhmedaldamJun 9 2022

Hello all,
I have two processes in pl/sql that are entering data into postgresql via DB link. My problem is when the second process fails, I want to rollback the data in the first process. Is there any way I can do this here...or do I need to create a procedure that will clear the data in the first process?

Thanks a lot in advance.

Comments
Post Details
Added on Jun 9 2022
7 comments
666 views