From: Rich Richardson <therichardsons@tdi.net>
Subject: Re: How Insert Images in Oracle 7
Date: 1998/06/27
Message-ID: <3594FA95.5BD1@tdi.net>#1/1
Content-Transfer-Encoding: 8bit
References: <359388FC.F34C43B3@emfa.pt>
Mime-Version: 1.0
To: microcentro@emfa.pt
Content-Type: text/plain; charset=iso-8859-1
Organization: Internet Email Account
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases.oracle.tools



Hello, what you need to do is use Sql*Loader to load the appropriate
fields in the database. Remember that this will not be in binary format
so for external use (like the web) you will need to write some code to
get the records and then store them in the appropriate format for
viewing. When you use Sql*Loader you will need to make sure that your
field lengths are large enough for the proper values. If you need more
info on a good loader control file let me know.

Rich.


DINFA - Microcentro wrote:
> 
> Hi
> The SQL *PLUS for Oracle 7 Manual says that the Long Row Data Type is
> used to keep binary Data like images and digital sound.
> I´d like to know how can I put a BMP image or other in a Table´s field.
> Which Statement to use, syntax ...
> Regards