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 |
NPL-00419: received ASN.1 object identifier with sub-identifier that is too large
ORA-08315: sllfrb: Error reading file
NNL-01072: Administrative region name: string
ORA-01604: illegal number range in clause "string" of string
ORA-38736: Wrong thread number string in flashback log file header.
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...
ORA-28106: input value for argument #string is not valid
ORA-32605: invalid REBUILD option
ORA-23494: too many rows for destination "string"
ORA-22886: scoped table "string" in schema "string" is not an object table
ORA-02057: 2PC: string: bad two-phase recovery state number string from string
LSX-00158: base type of "~S" must be simple type or primitive datatype