PLS-00403: expression 'string' cannot be used as an
INTO-target of a SELECT/FETCH statement
Answer / guest
Cause: A FETCH statement was unable to assign a value to an
assignment target in its INTO list because the target is not
a legally formed and declared variable. For example, the
following assignment is illegal because 'Jones' is a
character string, not a variable: FETCH my_cur INTO 'Jones';
Action: Check the spelling and declaration of the assignment
target. Make sure that the rules for forming variable names
are followed.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 2 No |
RMAN-08022: channel string: restoring archive log
RMAN-08588: converted datafile=string
TNS-01151: Missing listener name, string, in LISTENER.ORA
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-29280: invalid directory path
ORA-01643: system tablespace can not be made read only
DRG-10306: server terminated unexpectedly while processing command
ORA-23447: missing user parameter value
ORA-40209: setting % is invalid for % function
ORA-25292: Cannot add buffer on the specified queue
ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string
ORA-30558: internal error [string] in function based index