Hi,
I am invoking a Oracle StoredProcedure, I am able to compile it without any issues, but when I run it I am getting the below errors:-
ORA-02067: transaction or savepoint rollback required
ORA-02067: transaction or savepoint rollback required
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required
I have used an Oracle DATALINK to connect to the connect to a remote schema for this operation.
CREATE PUBLIC DATABASE LINK TEST_LINK CONNECT TO
test IDENTIFIED BY test USING 'localhost:1521/testSID';
Please let me know what is the problem here?
Thanks