Re: Help inserting Long Raw with PL/SQL

A copy of this was sent to spaniol_at_interact.ch (if that email address didn't require changing) On Thu, 21 Oct 1999 09:52:36 GMT, you wrote:

>Hi,
>I'm running Oracle Server 8.1.5 on both NT (sp5) and on Solaris
>2.6 OS.
>I need to load several millions of pictures (TIFF) (size between
>14k and 0.4M) into the DB.
>I must use LONG RAW and not BLOB datatype, because it is the
>whish and order of our Customer.
>(Also forbidden is anything that sound or even just smells like
>JAVA i.e. I must not just write a small java class which loads
>the File into the DB).
>
>I Know how to load one single picture at time from the HD into
>the DB using the SQL*Loader (Every picture seems to need it own
>cfg File).
>
>Now the Question: Is it possible to load the pictures using
>PL/SQL ?
>

No it is not.

Pro*C -- yes.
OCI -- yes.
PL/SQL -- no.

can you use C? I some some OCI that will do it for you.

>I have allready asked the ORACLE support Center, but I'm stiil
>waiting ( since ages) to their reply even though repetetive calls
>
>Any help will be appreciated
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 21 1999 - 07:49:31 CDT