hi,
i using procedure to insert record whereby that record have photo or it is a image file.
i select from other database and insert into another database.
when i exec this procedure , the error come up
Error : ORA-06502: PL/SQL: numeric or value error
below is my coding the procedure
PROCEDURE p_ins_jbai_dahi IS
mugshot long raw (32767);
cursor c1 is
select DM_REG_ICNO,DM_NATION,DM_DOC_NO,DM_MUGSHOT,CREWHO, CREDATE,MODWHO,MODDATE from
dc_ms@JBAI.WORLD
WHERE dm_doc_no in (select vp_frid from
cst_vp@dahi.visa.jim.my
WHERE vp_regicno = '5845'
and vp_plksno = '010'
and vp_reqno = '38');
BEGIN
for c in c1 loop
DBMS_OUTPUT.PUT_LINE(C.DM_DOC_NO || '001');
mugshot := c.dm_mugshot;
insert into dc_ms(DM_REG_ICNO,DM_NATION,DM_DOC_NO,DM_MUGSHOT,C REWHO,CREDATE,MODWHO,MODDATE)
values (c.DM_REG_ICNO,c.DM_NATION,c.DM_DOC_NO,MUGSHOT,c.C REWHO,c.CREDATE,c.MODWHO,c.MODDATE);
commit;
end loop;
exception
when others then
dbms_output.put_line('Error : '|| sqlerrm);
END;