Re: BLOB, CLOB

"Simon Walchshofer" <simon.walchshofer_at_students.uni-linz.ac.at> wrote in message news:<3cd530d1_at_news.uni-linz.ac.at>...
> Hi!
>
> Is it possible to insert for example a picture into a table with one
> sql-insert statement?
>
> e.g.
> create table myLob (id number, picture clob);
>
> insert into myLob values (1, ??????????);
>
> Is there a possibility to specify the file-path directly in the
> insert-statement??
>
> THX
> Simon

Like other people suggested, dbms_lob will do the job if your image file is located on your database server. If you access LOB from API programs you may need to use functions/classes instead of SQL to load your image. Either way, you can only update a LOB. So you need to first have a valid LOB locator created by an insert. You may want to take a look at the CHUNKSIZE parameter. If it's set incorrectly these LOBs can eat up your space quickly.

If you use external storage (BFILE) I believe you can do it with a single insert statement. But I don't remember the syntax. Received on Mon May 06 2002 - 16:18:21 CDT