Re: want to download .txt on unix server from form

A copy of this was sent to Thenardier_at_POBoxes.com.hk (ªü´ö Thenardier) (if that email address didn't require changing) On Mon, 28 Sep 1998 17:08:18 GMT, you wrote:

>
>hello,
>
>there is a .txt file generated by text_io with concurrenct manager
>in oracle appl. the output is saved in a directory on the unix
>server. now i want to get the .txt file (name predefined) directly
>from the server to a client pc using form. for security's sake, the
>users are not allowed to user any ftp software and are not allowed
>to know the logon name and password of the server.
>
>dont want to run the file generation process from form on pc. it's
>going to occupy the machine for a whole day. u know, forms dont
>run at the background. :(
>
>i really wonder how form can deal with such situation.
>
>thanx!
>
>rgds,
>thenard
>-------
>Pls remove .hk in reply

[Quoted] Well, you could write a stored procedure that uses UTL_FILE to open and read the the generated text file on the server and give back the file in 32k pieces to the client.

so, if you write a package on the SERVER using UTL_FILE, you could achieve this... You would call the package from forms and let forms use the TEXT_IO client package to save the text locally for the user...

Or, if you have Oracle8 -- you can use the BFILE type to open and read the file as well instead of using utl_file...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.