Answer / guest

Cause: A length for the ROWID, DATE, or MLSLABEL external
datatype was specified in an EXEC SQL TYPE or EXEC SQL VAR
statement. This is unnecessary because those are fixed
length types.

Action: Remove the length specification from the EXEC SQL
TYPE or EXEC SQL VAR statement.

Please add more information about this Error

ORA-32696: HTI: No free slot

1 Answers  

---

ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  

---

ORA-31052: Cannot delete ACL with other references

1 Answers  

---

PLS-00588: unqualified instance attribute references allowed only in member methods

1 Answers  

---

SQL*Loader-00282: Unable to locate character set handle for character set ID (number).

2 Answers  

---

NZE-28801: invalid object type

1 Answers  

---

KUP-04002: error getting file size for file string

1 Answers  

---

PCC-00116: This array already given in an ARRAYLEN statement

1 Answers  

---

ORA-08004: sequence string.NEXTVAL string stringVALUE and cannot be instantiated

1 Answers  

---

NNL-00203: Scheduled shutdown to occur in string

1 Answers  

---

ORA-14505: LOCAL option valid only for partitioned indexes

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

0 Answers   IBM,

---