PLS-00713: attempting to instantiate a type that is NOT
INSTANTIABLE



PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE..

Answer / guest

Cause: An attempt was made to instantiate a type that is
defined as NOT INSTANTIABLE.

Action: Avoid instantiating variables of this NOT
INSTANTIABLE type, instead derive an INSTANTIABLE subtype
from it and instantiate variables of the subtype.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02211: invalid value for PCTFREE or PCTUSED

1 Answers  


ORA-12602: TNS: Connection Pooling limit reached

1 Answers  


ORA-07585: spdcr: $PARSE failure

1 Answers  


ORA-06124: NETTCP: timeout waiting for ORASRV

1 Answers  


DRG-50859: failed to allocate statement handle

1 Answers  






DRG-11837: Reauthorization Required

1 Answers  


ORA-32827: Messaging Gateway agent must be shut down

1 Answers  


ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'

1 Answers  


DRG-11820: Unauthorized

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,


RMAN-20211: FROM TIME is before RESETLOGS time

1 Answers  


TNS-00512: Address already in use

1 Answers  


Categories