Error=>PL/SQL: ORA-00984:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Error=>PL/SQL: ORA-00984:

Threaded View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Error=>PL/SQL: ORA-00984:

    Hi,

    This is somewhat interesting,please clear this doubt,

    My database(9.2.0.6) trigger contains the following insert statement in it,

    INSERT INTO Document_execption ( c_id,
    c_desc,
    c_old_status,
    c_new_status,
    d_exception_date)
    values (I.C_ID,
    substr(sqlerrm,1,200),
    :OLD.C_STATUS,
    :NEW.C_STATUS,
    SYSDATE);


    This trigger is compiled successfully in oracle version 9.2.0.6.

    But the same trigger in database version 9.2.0.8 gives the following error,

    PL/SQL: ORA-00984: column not allowed here

    It points to the column substr(sqlerrm,1,200),then i changed to it,

    ERRMSG:=sqlerrm

    INSERT INTO Document_execption ( c_id,
    c_desc,
    c_old_status,
    c_new_status,
    d_exception_date)
    values (I.C_ID,
    ERRMSG,
    :OLD.C_STATUS,
    :NEW.C_STATUS,
    SYSDATE);


    Then the trigger is compiled successfully.

    What could be the reason for this error? Is this due to version difference or
    i've to do anything so that i can use the same code as it is in 9.2.0.6 without
    modifying anything in insert statement?

    Thanks..
    Last edited by malru; 06-15-2007 at 02:19 AM.

Posting Permissions

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


Click Here to Expand Forum to Full Width