Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    31

    Unanswered: ORA - 04098 trigger 'G203AHE.TD_DBCHNGREQ' is invalid and failed re-validation

    Hello everyone,

    When running the simple delete command

    Code:
    DELETE from DBCHNGREQ WHERE DBCHNGREQ_NR = 293;
    i get the following error

    ORA - 04098 trigger 'G203AHE.TD_DBCHNGREQ' is invalid and failed re-validation
    has anyone got any clue on how to resolve this error?

    thanks for looking

    Scott

  2. #2
    Join Date
    Aug 2006
    Posts
    31

    Also...

    When i tried this i didnt undertand the response,

    Code:
    SQL> show errors trigger G203AHE.TD_DBCHNGREQ;
    Errors for TRIGGER G203AHE.TD_DBCHNGREQ:
    
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    9/5      PL/SQL: SQL Statement ignored
    10/12    PL/SQL: ORA-00942: table or view does not exist
    SQL>
    anyone who has encountered this before please help

    Scott

  3. #3
    Join Date
    Aug 2006
    Posts
    31
    i dropped the table to try again..

    it always comes up with the error after the second row?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oracle says that trigger uses a table which is not available in this schema.

    It isn't easy to guess what might be wrong because you didnt provide trigger code (which would be, if you ask me, essential - do you really expect someone to read your mind or, by some magic, connect to your database to see it by himself?), perhaps tables' descriptions and other related stuff.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Your problem is put out in plain english

    Errors for TRIGGER G203AHE.TD_DBCHNGREQ:

    Code:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    9/5      PL/SQL: SQL Statement ignored
    10/12    PL/SQL: ORA-00942: table or view does not exist
    On line 10 column 12 of the sql block (begin through end) in the code segment of the trigger RD_DBCHNGREQ a table is being referenced that does not exist. What could be plainer. Look at the trigger and see what the missing table is.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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