---Para convertir una tabla de long raw a BLOB

CREATE TABLE my_docs (
  id    NUMBER(10)     NOT NULL,
  name  VARCHAR2(200)  NOT NULL,
  doc   BLOB           NOT NULL
);

create table my_pics ( id number(10), name varchar2(100), pics long raw);

alter table my_pics modify pics blob;

---Para BLOB to long raw

create or replace procedure blobtolongraw is
srcClob IN CLOB,vBuffer    VARCHAR2 (32767);
l_amount   BINARY_INTEGER := 32767;
l_pos      PLS_INTEGER := 1;
l_clob_len PLS_INTEGER;
BEGIN
select <campoimagen> into srcClob
from <tabla>
where <condicional> for select;
 l_clob_len := dbms_lob.getlength(srcClob);
  WHILE l_pos < l_clob_len
  LOOP
    dbms_lob.read(srcClob, l_amount, l_pos, vBuffer);
    IF vBuffer IS NOT NULL THEN
      -- write it to the raw datatype
    END IF;
    l_pos := l_pos + l_amount; 
  END LOOP;
         --update the table
  RETURN;
EXCEPTION
  WHEN OTHERS THEN
    RAISE;
END;
/

---Javier Delgado Vite