StoredProcedure Issue

[Rithanya Laxmi]

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

[Roel De Nijs]

You are not providing many details, so don't expect to get much help. Maybe this post might give you some pointers.

[Brian Tkatch]

Rithanya Laxmi wrote: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

The error is rather descriptive, you cannot do that without a ROLLBACK. Just because you can compile an SP does not mean you can execute it. Compilation and execution check different things.