Re: Inserting text data into BLOB fields

Use dbms_lob package.
in this package there are few modules which help you to handel lobs. There is a procedure which is called (I am not soure on this) dbms_lob.loadfrom_file
which you will pass a file pointer and lob pointer to it. But Remeber to default the lob pointers by using only emty_lob(); eg Mylob lob :=empy_lob();

this Mylob lob default null; will NOT WORK.

steps
1 create a tablke with lob data type in it in your procedure

2- decalre lob variable default it to null (empty_lob())
3-open the test file
4-select the lob pointer from you table

    select lob from lob_tab in to lob_var where conditions..; (If data in lob column is more that 4K oracle will only keep the pointer to the lob in the table).
using load from file procedure in the dbms_lob package load the data.

All the best Tom

Tom Deseamus <elricd_at_mindspring.com> wrote in message news:87vudo$kuh$1_at_nntp4.atl.mindspring.net...
> Anyone know how to save large amounts of text data to BLOB fields?
>
> --
> Tom
>
>
Received on Fri Feb 11 2000 - 04:30:19 CET