In the catalog at www.robonerd.com (ROBO Books International) there is
a complete graphics example application using PL/SQL and JAVA to load
and display image data, perhaps this will help you.
Mike
"Dmitry" <support_at_ispirer.com> wrote in message news:<ar5ojb$fcijh$1_at_ID-75577.news.dfncis.de>...
> Hi,
>
> In addition to programming languages like C/C++/Java etc, you can use Oracle
> SQL Loader.
>
> For example, for given table
>
> CREATE TABLE blob1
> (col1 VARCHAR2(100),
> col2 BLOB);
>
> create a text file, containing
>
> image1 name, image1.jpg
> image2 name, image2.jpg
> image3 name, image3.jpg
> image4 name, image4.jpg
> ...
>
> Specify real image files instead of imageN.jpg and fill other columns.
>
> Then create a control file for SQL Loader:
>
> LOAD DATA
> INFILE 'blob1.txt'
> INTO TABLE BLOB1
> INSERT
> FIELDS TERMINATED BY ',' TRAILING NULLCOLS
> (COL1 OPTIONALLY ENCLOSED BY '"',
> COL2_FILE FILLER OPTIONALLY ENCLOSED BY '"',
> COL2 LOBFILE (COL2_FILE) TERMINATED BY EOF NULLIF COL2_FILE='')
>
> Then run SQL Loader:
>
> sqlldr userid=usr/usr control=blob1.ctl log=blob1.log
>
> It will load your images to an Oracle database
>
>
> Best regards, Dmitry
> --
> http://www.ispirer.com/products - Database migration tool for Oracle, DB2,
> MS SQL Server, Sybase and MySQL.
>
>
> "Butt, Naseem [CAR:7622:EXCH]" <nbutt_at_americasm01.nt.com> wrote in message
> news:ar0pj9$60q$1_at_bcarh8ab.ca.nortel.com...
> > Can someone help me to understand how ti import images into an Oracle
> table.
> > I have created the table using the BLOB datatype to store the
> images....need
> > o understand the SQL code to import the data ?
> >
> > Thanks,
> >
> > Naseem
> >
> >
Received on Mon Nov 18 2002 - 14:51:47 CST
