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
- 2302 Views
- IBM, I also Faced
- E-Mail Answers
ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.
ORA-02269: key column cannot be of LONG datatype
ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string
TNS-00556: no method specified for wallet retrieval
TNS-01181: Internal registration connection limit reached
RMAN-10003: unable to connect to target database
NNL-00289: Scheduled cache flush to occur in string
ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
ORA-13412: invalid scale parameter
ORA-31622: ORACLE server does not have string access to the specified file
IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier
ORA-16739: log transport service for standby "string" unexpectedly online
Oracle Errors 
