oracle - ORA-00932 in cursor fetch -

i have run strange problem in working code. there working procedure pkg_pbrer.p_gen_pbrer_rpt returns v_po_report output cursor.

i trying capture cursor table_po_report_62 , working fine.

now facing error of

ora-00932: inconsistent datatypes: expected - got -" in cursor fetch statement.

for simplicity of understanding, have omitted unnecessary lines of code.

declare    v_po_report sys_refcursor;    type type_po_report_62 record (soc varchar2(1000), pt varchar2(1000), mp varchar2(1000),                                    blind varchar2(1000), ac varchar2(1000), placebo varchar2(1000));    table_po_report_62 type_po_report_62;      --     --     -- working code     --     --      -- initializing reference cursor         open v_po_report 'select 1 dual';      pkg_pbrer.p_gen_pbrer_rpt (v_user_id,v_report_type,v_report_form_id,v_reg_report_id,v_po_report,v_po_case_list);    loop         fetch v_po_report table_po_report_62;         -- encountered ora-00932: inconsistent datatypes: expected - got -         exit when v_po_report%notfound;         insert pbrer_output62_report (soc, pt, mp, blind, ac, placebo)         values (table_po_report_62.soc, table_po_report_62.pt, table_po_report_62.mp, table_po_report_62.blind, table_po_report_62.ac, table_po_report_62.placebo) ;   end loop;     close v_po_report;  exception when others    --     --     -- working code     --     --  end; 

check cursor data added records may unconvertable oracle. exmaple column accept varchar2 has value '1000' able convert oracle number value 'abc' not.