Re: How to load binaries with SQL?

You can do it with an SQL statement. Or rather a PL/SQL statement or stored procedure that calls
DBMS_LOB.LOADFROMFILE. I'm not a perl scripter but if DBI can call stored procedures then you can do this using perl.

There is a chapter devoted to LOBs in Jonothan Lewis' excellent book Practical Oracle 8i. DBMS_LOB is also documented in the Oracle documentation.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"penpendisarapen" <penpendisarapen_at_MailAndNews.com> wrote in message
news:3AFFBD54_at_MailAndNews.com...


> >===== Original Message From connor_mcdonald_at_yahoo.com =====

> >penpendisarapen wrote:

> >>

> >> Help out a newbie.

> >>

> >> Images are stored in our product table under the picture field. Can I

 load
 a


> >> .gif or .jpg file to the picture field with a SQL statement?

> >>

> >> TIA

> >>

> >> Victor

> >

> >This can be done with SQL Loader - see the examples in the case studies,

> >or using the DBMS_LOB package...

> >

> >hth

> >connor

> >--

>
>
> So, it can't be done with an SQL statement? I was actually hoping to write
 a
> Perl script using DBI to do batch loads.
>
> Where can I find the case studies? Sorry for asking, I'm new to this and
> we're
> in the process of hiring a DBA.
>
> Thanks,
>
> Victor
>