Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Trigger Exception

    CAN ANY ONE PLEASE LET ME KNOW WHAT IS THE SOLUTION FOR THIS EXCEPTION

    java.sql.SQLException:
    ORA-01438: value larger than specified precision allows for this column
    ORA-06512: at "TBD.RST_RI_STATE_TR_AI", line 3
    ORA-04088: error during execution of trigger 'TBD.RST_RI_STATE_TR_AI'

    My Trigger is

    CREATE OR REPLACE TRIGGER "TBD"."RST_RI_STATE_TR_AI" AFTER INSERT ON "RST_RFI_STATE"
    FOR EACH ROW
    BEGIN
    IF :NEW.RFI_STATE_NAME='RF' THEN
    UPDATE RSAT_RFI SET
    RESPONSIBLE_PERSON_ID=:NEW.RESPONSIBLE_PERSON_ID
    WHERE RFI_ID = :NEW.RFI_ID;
    END IF;

    UPDATE RSAT_RFI SET
    CURRENT_STATE_ID=:NEW.RFI_STATE_ID
    WHERE RFI_ID = :NEW.RFI_ID;
    END;

  2. #2
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: Trigger Exception

    Originally posted by Harikishan
    CAN ANY ONE PLEASE LET ME KNOW WHAT IS THE SOLUTION FOR THIS EXCEPTION

    java.sql.SQLException:
    ORA-01438: value larger than specified precision allows for this column
    ORA-06512: at "TBD.RST_RI_STATE_TR_AI", line 3
    ORA-04088: error during execution of trigger 'TBD.RST_RI_STATE_TR_AI'

    My Trigger is

    CREATE OR REPLACE TRIGGER "TBD"."RST_RI_STATE_TR_AI" AFTER INSERT ON "RST_RFI_STATE"
    FOR EACH ROW
    BEGIN
    IF :NEW.RFI_STATE_NAME='RF' THEN
    UPDATE RSAT_RFI SET
    RESPONSIBLE_PERSON_ID=:NEW.RESPONSIBLE_PERSON_ID
    WHERE RFI_ID = :NEW.RFI_ID;
    END IF;

    UPDATE RSAT_RFI SET
    CURRENT_STATE_ID=:NEW.RFI_STATE_ID
    WHERE RFI_ID = :NEW.RFI_ID;
    END;
    check out the value that the trigger is updating.
    It seems that the data that is been updated is more than defined in the table.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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