Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
I have four tables those are emp,dept,eliminate and uneliminate.
i wrote small cursor..when i run, it display one error
(ORA-01403 nodata found)...
The query is:
Declare
cursor c1 is
select e.ename emp_name from emp e,dept d where
e.deptno=d.deptno group by deptno;
r1 c1%rowtype;
test_emp varchar2(200);
begin
for r1 in c1
loop
begin
select eliminate_emp into test_emp from eliminate
t,uneliminate ut where t.number=ut.number
and t.deptno=e.deptno and rownum<1;
end;
dbms_output.put_line(r1.emp_name);
end loop;
end;
Thanks...
- 0 Answers
- 2802 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)
TNS-04201: Trace Assistant Usage ERROR: Missing File name
ORA-13284: failure to copy geometry object for conversion in place
ORA-00052: maximum number of enqueue resources (string) exceeded
ORA-22869: depth of type dependency hierarchy exceeds maximum limit
RMAN-06057: a standby controlfile cannot be included along with a current controlfile
ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded
RMAN-08029: snapshot controlfile name set to default value: string
ORA-30951: Element or attribute at Xpath string exceeds maximum length
ORA-00064: object is too large to allocate on this O/S (string,string)
ORA-16739: log transport service for standby "string" unexpectedly online
DRG-11410: could not insert into string result table
Oracle Errors 
