Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
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.
If you are experiencing a similar issue, please ask a related question
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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
- Acronis
- Databases
- Oracle Database
- MongoDB
- Oracle
- *Backup Software
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month6 days, 12 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.