Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00153: A string type may only be used as an object type
attribute.



PLS-00153: A string type may only be used as an object type attribute...

Answer / guest

Cause: A POINTER or [SIGNED/UNSIGNED] BINARY INTEGER can
only be used as attributes of object types. These types can
only be referenced in CREATE TYPE statements, and are
non-queryable data types. One of these external PL/SQL types
outside of an object type.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NPL-00419: received ASN.1 object identifier with sub-identifier that is too large

1 Answers  


ORA-08315: sllfrb: Error reading file

1 Answers  


NNL-01072: Administrative region name: string

1 Answers  


ORA-01604: illegal number range in clause "string" of string

1 Answers  


ORA-38736: Wrong thread number string in flashback log file header.

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-28106: input value for argument #string is not valid

1 Answers  


ORA-32605: invalid REBUILD option

1 Answers  


ORA-23494: too many rows for destination "string"

1 Answers  


ORA-22886: scoped table "string" in schema "string" is not an object table

1 Answers  


ORA-02057: 2PC: string: bad two-phase recovery state number string from string

1 Answers  


LSX-00158: base type of "~S" must be simple type or primitive datatype

1 Answers  






Categories