Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    9

    Question Unanswered: And I fix this how? ORA-02067: transaction or savepoint rollback required

    Hi All

    Does anybody know what i can do about this?

    This happens when we run a proc to update our data warehouse.

    I found the table that's affected and can probably change the size of the affected column to accept the insert but what do I do about ORA-02067: transaction or savepoint rollback required ?

    Thanks in advance.

    Graham

    21:30:03 SQL> set serveroutput on
    21:30:03 SQL>
    21:30:03 SQL> connect milk/*@ware
    Connected.
    21:30:04 SQL> set serveroutput on
    21:30:04 SQL> execute ware_live;
    ERROR:
    ORA-02067: transaction or savepoint rollback required


    BEGIN ware_live; END;

    *
    ERROR at line 1:
    ORA-02055: distributed update operation failed; rollback required
    ORA-01438: value larger than specified precision allows for this column
    ORA-06512: at "WARE.WARE_LIVE", line 244
    ORA-06512: at line 1


    23:56:19 SQL> disconnect
    ERROR:
    ORA-02067: transaction or savepoint rollback required


    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
    With the Partitioning option
    JServer Release 8.1.7.1.1 - Production (with complications)
    23:56:19 SQL>
    23:56:19 SQL> spool off

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Do what the docs say?
    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.
    You will certainly need to fix the table (or the data) to avoid the cause of the problem.

  3. #3
    Join Date
    Sep 2004
    Posts
    9
    Thanks

    Thought there was more to it than that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •