Cause: An assignment target in the INTO list of a FETCH statement does not

PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables

Question Posted / guest

1 Answers
7480 Views
I also Faced
E-Mail Answers

Answer Posted / guest

Cause: An assignment target in the INTO list of a FETCH
statement does not match in datatype with the corresponding
column in the select list of the cursor declaration, and it
is unclear which implicit conversion is required to correct
the mismatch.

Action: Change the cursor declaration or change the datatype
of the assignment target. You might want to use datatype
conversion functions in the select list of the query
associated with the cursor.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

ORA-26030: index string.string had string partitions made unusable due to:

1988

ORA-16627: No standby databases support the overall protection mode.

4037

ORA-26094: stream format error: input column overflow

2854

ORA-26079: file "string" is not part of table string.string

2003

ORA-26095: unprocessed stream data exists

3639

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1665

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2860

RMAN-05017: no copy of datafile number found to recover

2465

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3438

ORA-26029: index string.string partition string initially in unusable state

2229

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...

2661

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2860

ORA-26032: index string.string loading aborted after string keys

2177

IMP-00064: Definition of LOB was truncated by export

6465

IMG-02003: 2FF03 - incorrect color histogram feature specification

1762