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 |
RMAN-10026: network error number-number occurred registering connection
DRG-11108: invalid filename specified: string
QSM-02127: not supported for this type mv by Oracle version at master site
LSX-00341: ENTITY or ENTITIES type may only be used in attributes
NCR-01004: NCRS: Write error.
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-07476: slsget: cannot get mapped memory statistics.
ORA-39019: invalid operation type string
TNS-00090: * Interchange - will ask the Interchange
ORA-30355: materialized view container does not exist
ORA-31409: one or more values for input parameters are incorrect
QSM-01619: equivalence cannot be used in ENFORCED integrity mode