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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.