Be seen. Boost your question’s priority for more expert views and faster solutions
Solved
Compile error in Oracle Reports Developer.
Posted on 2004-03-25
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?
1 Comment
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
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
Featured Post
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.
Join & Write a Comment Already a member? Login.
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
(CODE)
This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
606 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.