pl/sql PROBLEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: pl/sql PROBLEM

  1. #1
    Join Date
    Apr 2001
    Posts
    142
    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.

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    1) does this object (probably a sequence according to its name) exists :
    CS61MDAOWN.PCM_RECENTCHANGES_SEQ

    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

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