Answer / guest

Cause: The object in the SQL statement following this error
was created with compilation errors. If this error occurred
for a view, it is possible that the base table of the view
was missing.

Action: This is a warning. The object may have to be
recompiled before being used.

Please add more information about this Error

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   IBM,

---

SQL*Loader-00529: OCI return status: invalid handle

1 Answers  

---

DRG-50948: ABOUT clause required in the absence of a text index

1 Answers  

---

ORA-30022: Cannot create segments in undo tablespace

2 Answers  

---

ORA-13825: missing SQL statement text for create SQL profile

1 Answers  

---

DRG-10822: duplicate query name

1 Answers  

---

ORA-19606: Cannot copy or restore to snapshot controlfile

1 Answers  

---

LPX-00223: external entity "~s" found in an attribute value

1 Answers  

---

ORA-01234: cannot end backup of file string - file is in use or recovery

1 Answers  

---

TNS-03509: OK (number msec)

1 Answers  

---

LFI-01509: fopen() failed(OSD return value = string).

1 Answers  

---

ORA-28030: Server encountered problems accessing LDAP directory service

1 Answers  

---