PLS-00583: size must be specified if opaque type is fixed-length



PLS-00583: size must be specified if opaque type is fixed-length..

Answer / guest

Cause: An attempt was made to declare a fixed-length opaque
type without specifying an explicit size.

Action: Specify an explicit size, or change the declaration
to be varying-length.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

1 Answers  


ORA-25462: evaluation context not specified

1 Answers  


ORA-12323: unable to open database (link name string)

1 Answers  


ORA-15032: not all alterations performed

1 Answers  


TNS-12223: TNS:internal limit restriction exceeded

1 Answers  






QSM-02036: in-list present in mv

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,


ORA-06569: Collection bound by bind_array contains no elements

1 Answers  


LPX-00322: A doc referred by XSLT stylesheet could not be opened : ~s

1 Answers  


ORA-13765: Value "string" is illegal for a result limit.

1 Answers  


ORA-14408: partitioned index contains subpartitions in a different tablespace

1 Answers  


ORA-02432: cannot enable primary key - primary key not defined for table

1 Answers  


Categories