Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help inserting Long Raw with PL/SQL

Help inserting Long Raw with PL/SQL

From: <spaniol_at_interact.ch>
Date: Thu, 21 Oct 1999 09:52:36 GMT
Message-ID: <7umnp0$nnk$1@nnrp1.deja.com>


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 ? 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. Received on Thu Oct 21 1999 - 04:52:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US