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;

Can you please tell us what the environment you are useing is?

hi,
what your means by "environment". can you give the example?