Converting a blob to long raw (over 32k)

Hello all,

I am trying to convert a blob back to a long raw. Works great except when the blob is over 32k.

Here is what I have.

    SELECT obj_photo_lob INTO v_blob_update     FROM custom_dev.INTERFACE_STAGE_EMP_PHOTO ep     WHERE ep.emp_ssn = rec_update_images.emp_ssn     ;
-- find the length of the blob (bytes)

v_length := dbms_lob.GETLENGTH(v_blob_update);

• Set the amount (bytes) to be converted equal to the length of the blob. v_text_amount := v_length;
• Enable dbms_output and display length of the blob. dbms_output.enable; dbms_output.put_line('length = '||v_length);

--Convert blob to long raw
while v_text_pos <= v_length loop

    dbms_lob.read(v_blob_update,v_text_amount,v_text_pos,v_raw);     v_text_pos := v_text_pos + v_text_amount;     --dbms_output.put_line('In Update Loop'); end loop;

Insert into long raw table. Received on Fri Nov 12 2004 - 10:58:33 CST