Answer / guest

Cause: While looking for prior declarations of a cursor,
procedure, function, or package, the compiler found another
object with the same name in the same scope. Or, the headers
of subprogram in a package specification and body do not
match word for word.

Action: Check the spelling of the cursor, procedure,
function, or package name. Also check the names of all
constants, variables, parameters, and exceptions declared in
the same scope. Then, remove or rename the object with the
duplicate name. Or, change the headers of the packaged
subprogram so that they match word for word.

Please add more information about this Error

LFI-01522: opendir() failed.

1 Answers  

---

ORA-01507: database not mounted

1 Answers  

---

SQL*Loader-00512: Unable to free read buffer

1 Answers  

---

ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  

---

ORA-12806: could not get background process to hold enqueue

1 Answers  

---

ORA-16597: Data Guard broker detects two or more primaries.

1 Answers  

---

ORA-01874: time zone hour must be between -12 and 13

1 Answers  

---

SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  

---

ORA-19563: %s header validation failed for file string

1 Answers  

---

RMAN-06159: error while looking up backup set

1 Answers  

---

TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  

---

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...

1 Answers   IBM,

---