Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help inserting Long Raw with PL/SQL
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
![]() |
![]() |