| Error - PL/SQL: ORA-00984 [message #244876] |
Thu, 14 June 2007 07:26  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
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..
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
