A form is calling sql*loader and up into the db !
Here is what the ctl file look like :
LOAD DATA
INTO TABLE moh_dmm_ref
APPEND
FIELDS TERMINATED BY ';'
(
id_media INTEGER EXTERNAL(15),
...,
date_fin date(10) "DD/MM/YYYY",
extern_file FILLER CHAR(100),
support_media LOBFILE(extern_file) TERMINATED BY EOF
)
As for showing the images back, I do not know , our
frontend is a mix of StoryServer, php, Perl,....
- L <leed_at_chele.cais.net> a écrit : > Can you help
me on following two things:
>
> 1. how to insert or sqlloader or from ORACLE FORM
> into ORACLE database?
>
> 2. which tool can query and display image?
>
>
> Thanks
>
>
> On Thu, 27 Jul 2000, [iso-8859-1] paquette stephane
> wrote:
>
> > Hi,
> >
> > You can use blob for the images, clob is for text.
> > We're using both, blob for .gif and .jpg and clob
> for
> > text.
> >
> > Yes, you can query the images with the proper
> tool.
> >
> > I do not think that you can change the format of
> an
> > image stored in Oracle.
> >
> > --- Herman Susantio <Sherman_at_bcsis.com> a écrit :
> >
> > hallo guys,
> > >
> > > anyone knows how to store JPEG file in a
> database ?
> > > and in what datatype ?
> > > BLOB ? CLOB ?
> > >
> > > can we do the query for the image ?
> > >
> > > and if the image is already in the database,
> > > can we convert it into JPEG file ?
> > >
> > > thank you
> > >
> > > regards
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Author: Herman Susantio
> > > INET: Sherman_at_bcsis.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> > spaquette_at_houra.fr
> > (33) 01 53 93 06 50
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get Yahoo! Mail - Free email you can access from
> anywhere!
> > http://mail.yahoo.com/
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
>
> --
> Author: L
> INET: leed_at_chele.cais.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Wed Aug 16 2000 - 02:51:52 CDT
