Re: iAS, forms, file upload/download intermedia, mod_pl/sql

Hi Raul

You have to have the document table (you may call it what you like as long you define the table name in the DAD) There are some columns that are mandentory but you can add your own.

I have pl/sql package where I upload through a web page (not forms) add and some user specific information , one can liste the filese, delete the files and the files can be downloaded/displayed/opend. The packege is part of a minor system but should be easy to fit into most of your needs.
If you are interested I'll send it to you.

kind regards
Torben
torben.holm_at_miracleas.dk

rahul sharma wrote:

>Dear list
>
>1. what i want to build.
>docuement archive and search system, very similiar to metalink, in which all
>our company's project communications
>will be stored, emails, contacts, proposals, presentations etc.
>
>2. tools i would require
>iAS, mod_pl/sql, dev6i, context
>
>3. doubts
>after researching through metalink and asktom, i have a fairly good
>knowledge of how to do this, but still leaves
>a few questions un anwered..
>
>A) i plan to use a web form (dev 6i) to provide the interface for searching,
>and after going thru the documentations, i have
>found out that uploading/downloading files would not be easy from web forms
>(must use jave beans?), for this pl./sql cartridge would be easier.
>(i have tried using this and it works fine). Now my interface would provide
>the search capability and then would list the links to the documents,
>when clicked, these links would open a browser window to display the
>docuemtns. Also, for providing upload/download i would open a separate
>window , driven by mod pl/sql.
>
>
>B) this is regarding the "document table" .. can i use a table structure
>other than the standard document table to store docuemnts ??
>let say i use
>(doc_id numeber,
>key_words varchar2(100),
>document BLOB)
>
>can i still use mod pl/sql to upload/download from this table ? , the
>documentation is not very clear on this.
>
>Thanks you all very much
>
>Rahul
>
>
>
>
>
>
>
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Torben Holm
  INET: Torben.Holm_at_miracleAS.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).