Re: CLOBbered

From: FC <flavio_at_tin.it>
Date: Tue, 15 Apr 2003 08:12:40 GMT
Message-ID: <Y9Pma.15310$LB6.409466@news1.tin.it>

Check out DBMS_LOB package description in manual Supplied PL-SQL Package Reference (a76936), procedure LOADFROMFILE should solve your problem.

Bye,
Flavio

"Paul Murphy" <pmurphy_at_scsinet.com> wrote in message news:4MHma.70874$e8.372_at_twister.nyroc.rr.com...
> I've spent a few hours looking through all my Oracle books and scanning
some
> web sites and I can't find a simple, straightforward answer to what seems
to
> me to be a simple, very common task. I want to insert the contents of a
> plain text file (some files are up to 320 KB) into a CLOB column which I
> need to add to an existing table. I thought for sure there would be a
> built-in function so I could issue something like:
>
> UPDATE news
> SET article = InsertTextFile('C:\articles\article1.txt')
> WHERE title = 'Article One';
>
Received on Tue Apr 15 2003 - 03:12:40 CDT