Answer / guest

Cause: A variable declared with %TYPE or %ROWTYPE cannot
have a scale, precision, or range constraint. Example: x
y%TYPE(10) is not acceptable. It is legal to add "NOT NULL"
or non-conflicting CHARACTER SET constraints to anchored
type declarations.

Action: Remove the constraint or use a type name instead of
an anchored type.

Please add more information about this Error

LSX-00235: invalid URI "~S"

1 Answers  

---

PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

1 Answers  

---

ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE

1 Answers  

---

ORA-10570: Test recovery complete

1 Answers  

---

QSM-00776: the user-defined workload string is missing the following column: string

1 Answers  

---

ORA-30031: the suspended (resumable) statement has been aborted

1 Answers  

---

DRG-13306: 'len' attribute value must be in the range string..string, at line string

1 Answers  

---

ORA-12667: Shared server: outbound transport protocol different from inbound

1 Answers  

---

PLS-01450: This <value expression> contains a nonconforming data type

1 Answers  

---

ORA-00073: command string takes between string and string argument(s)

1 Answers  

---

ORA-19553: device name string is invalid

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,

---