Line # = 42 Column # = 8 Error Text = PLS-00201: identifier 'CS61MDAOWN.PCM_RECENTCHANGES_SEQ' must be declared
Line # = 42 Column # = 1 Error Text = PL/SQL: SQL Statement ignored
HI CAN ANYONE TELL ME WHAT THE PROBLEM IS WITH THIS, EVERY TIME I TRY AND COMPLIE THIS TRIGGER I GET THIS ERROR.
1) does this object (probably a sequence according to its name) exists :
2) if no, you have your answer
if yes : which user is owner of the trigger ?
3) if owner != CS61MDAOWN, then it might be a synonym or grant problem. make sure the trigger owner can see the object :
select * from all_objects
where owner = 'CS61MDAOWN'
and object_name = 'PCM_RECENTCHANGES_SEQ';
if you get an error, create a synonym
if you don't, grant select on the sequence to CS61MDAOWN
Click Here to Expand Forum to Full Width