Hi Tom!
I have a procedure ins_lob by which i insert file with contents into database.
For reading the data from database i have a procedure called read_lob which is like:
SQL> set serveroutput on size 100000
SQL> exec read_lob(7);
PL/SQL procedure successfully executed.
procedure read_lob(p_id in demo.id%type) is
Lob_loc BLOB;
m integer;
n integer;
BEGIN
SELECT theBlob INTO Lob_loc
FROM demo
WHERE id = p_id;
m := dbms_lob.getlength(lob_loc);
dbms_output.put_line('THE LENGTH IS: '||dbms_lob.getlength(lob_loc));
-- just print out the first 200 bytes since put_line
-- cannot do more then 255
for i in 1..m loop
if i =1 then
dbms_output.put_line(utl_raw.cast_to_varchar2( dbms_lob.substr( lob_loc, 230, 1 ) ) );
n := 230+230;
else
if n<m then
dbms_output.put_line(utl_raw.cast_to_varchar2( dbms_lob.substr( lob_loc,230,n ) ) );
n := n+230;
end if;
end if;
end loop;
END;

Using the above procedure, i am able to display the details too. But i need to retrieve the blob data which is having delimiters (like ','or '|') into separate fields of another table. That is first i will retrieve the data and give it as an input to another table. Can i try the same with BLOB datatype or shall i use CLOB datatype?
Hope to get your valuable feedback.
Thanks in advance
Daya