Xref: alice comp.databases.oracle.tools:24381
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.amsterdam.nl.net!sun4nl!C1S5EXCH.Origin-it.com
Newsgroups: comp.databases.oracle.tools
Date: Wed, 5 May 1999 20:57:31 +0200 
Message-ID: <373094A8.5B9F282F@nl.origin-it.com>
From: Joep Hendrix <joep.hendrix@nl.origin-it.com>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Pictures in Oracle Webserver application
References: <925930412.804005@jive.news.big-orange.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 31

Jeroen Oosterveld wrote:

> Dear oracle professional,
>
> I'm generating a webapplication using Oracle DB 7.3, Oracle webserver 3.0
> and Oracle Designer/2000 version 1.3.2.
> It's not possible te generate a HTML-document with pictures out of the
> database because "Raw/Long Raw" is not supported in Designer 1.3.2 while
> generating webapps. It should also be possible for the end-user to insert
> new pictures into the database, using the webapp. (Ctrl-C, Ctrl-V???
> UUencode???)
>
> Can anyone give me a work around?Thanks in advance!
>
> Greetings,
> Jeroen Oosterveld

Hello Jeroen,

Unfortunately there is no work around. When retrieving a picture you should
use a for instance c-program to extract the data out of the database:
<img src="c-program parameter">

On the other hand storing pictures from the client filesystem into the
database is not supported by the WAS3.0 PL/SQL cartridge. On oracle goverment
there is an alternative cartridge available. I am not sure but I think that
this uploading is supported by OAS4 though.

Joep Hendrix