Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    problem in insert record (photo or image file )

    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;

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    Can you please tell us what the environment you are useing is?
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  3. #3
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Red face what means by "environment "

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •