ORA-22307: operation must be on a user-defined type
Answer / guest
Cause: attempt to perform an operation that is allowed only
on a user-defined type, and the type is not a user-defined type.
Action: Check to make sure that only user-defined types are
being operated on.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-50803: failed to define output
ORA-30052: invalid lower limit snapshot expression
ORA-25407: connection terminated
NNL-01055: Requests received: number
ORA-15090: handle string is not a valid descriptor
ORA-27209: syntax error in device PARMS - unknown keyword or missing =
ORA-12423: invalid position specified
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...
RMAN-06169: could not read file header for datafile string error reason string
ORA-02226: invalid MAXEXTENTS value (max allowed: string)
ORA-29868: cannot issue DDL on a domain index marked as LOADING
ORA-29345: can not plug a tablespace into a database using a different character set