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?
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?
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
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