From oracle-l-bounce@freelists.org Wed May 5 22:56:19 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i463u4823542 for ; Wed, 5 May 2004 22:56:14 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i463ts623535 for ; Wed, 5 May 2004 22:56:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C20E972C998; Wed, 5 May 2004 22:46:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12716-78; Wed, 5 May 2004 22:46:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 273E672CA35; Wed, 5 May 2004 22:46:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 22:45:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D75B72CAB6 for ; Wed, 5 May 2004 22:45:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13799-18 for ; Wed, 5 May 2004 22:45:31 -0500 (EST) Received: from hotmail.com (bay12-f4.bay12.hotmail.com [64.4.35.4]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB89772CA1B for ; Wed, 5 May 2004 22:45:30 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 5 May 2004 20:47:43 -0700 Received: from 69.140.7.4 by by12fd.bay12.hotmail.msn.com with HTTP; Thu, 06 May 2004 03:47:43 GMT X-Originating-IP: [69.140.7.4] X-Originating-Email: [ichow2@hotmail.com] X-Sender: ichow2@hotmail.com From: "Ivan Chow" To: oracle-l@freelists.org Subject: how to store/retrieve html file and images in blob Date: Wed, 05 May 2004 23:47:43 -0400 Mime-Version: 1.0 Content-type: text/plain Message-ID: X-OriginalArrivalTime: 06 May 2004 03:47:43.0919 (UTC) FILETIME=[E35313F0:01C4331C] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4542 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ichow2@hotmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, I've a table that stores pdf, doc, html, images in blob and I'm using Forms9i to display the files. The records look like fileid filetype filename 1 word mydoc.doc 2 pdf mypdf.pdf 3 html myhtml.html 4 gif myphoto.gif >From the records above, I store each file as a separate record - one fileid refers to one filename, one filetype. I've no problem storing and retrieving files this way. Today however, I was given a homepage.html file that has embedded banner (banner.gif) and pictures ( 2 gifs) in it - a total of four files. I've no idea how I'm supposed to store this homepage.html file together with the multiple gif files in the table. I can store the homepage.html and the three gif files that it referenced as separate records but then I do not know how I'm supposed to use forms9i or any other software tools to retrieve the html file along with the gif files. Also, it does not make sense storing the four files as separate records since all the gifs belong to the same homepage html file. The only way I can think of is storing the html and gif files on the file system as bfile and use forms9i to retrieve the homepage.html. Does anyone has any suggestions? TIA Ivan _________________________________________________________________ Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------