Hi when i try to run a pl/sql s

[cyno]

Hi

when i try to run a pl/sql script i get the following error message.But the same script will run after sometime.Did anybody encountered the same problem.Help me......


SQL> citi.txt
ERROR:
ORA-02067: transaction or savepoint rollback required


DECLARE cc VARCHAR2(20);
*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-00904: invalid column name
ORA-06512: at line 125


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-02067: transaction or savepoint rollback required

 

[Turkbear]

Hi,
Find out what previous problem is causing that error:
From

http://tahiti.oracle.com:

ORA-02067 transaction or savepoint rollback required

Cause: A failure (typically a trigger or stored procedure with multiple remote updates) occurred such that the all-or-nothing execution of a previous Oracle call cannot be guaranteed.

Action: Roll back to a previous savepoint or roll back the transaction and resubmit.

So, find out the problem with the previous transaction...
( BTW, code excerpts would have helped narrow this down)