Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Course Of The Month
8 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 10 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.