Compile error in Oracle Reports Developer.

I'm getting an Error 201 in one of my Program Units.  The code is as follows:

function CF_revisionFormula return VARCHAR2 is
  rev_flag varchar2(1) := ' ';
begin
  select 'R' into rev_flag
    from operation_notes
  where :op_id = operation_notes.op_id and
            on_type_cd = 'T' and
            rownum = 1;
  return (rev_flag);
RETURN NULL; exception
  when others then return (' ');
end;

The error I receive is:  Error 201 at line 5, column 10 identifier 'OPERATION_NOTES' must be declared
                                  Error 0 at line 4, column 3  SQL Statement ignored.

I have other Program Units for other reports coded in the same mannor and I don't get an error on them.  Where should I start looking for the problem?
tareothleeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
baonguyen1Connect With a Mentor Commented:
Hi,

I could be:

1. The object 'OPERATION_NOTES does not exist, the name is misspelled or it is not in the  current schema.
2. You grant a role to a user but that role is disabled in PL/SQL.  You need to grant all permissions the user needs to access in PL/SQL explicitly.
3. YOu may need to grant some permissions to a user to run that code

HTH
0
All Courses

From novice to tech pro — start learning today.