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

From: <Thenardier_at_POBoxes.com>
Date: 1998/09/29
Message-ID: <6uq7rt$kqf$1_at_nnrp1.dejanews.com>#1/1


[Quoted] In article <3616c3a8.17560080_at_192.86.155.100>,
> tkyte_at_us.oracle.com wrote:
> 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...

thanx thomas, stored procedure created using UTL_FILE and it can read the text file. but i still donno how the TEXT_IO package can work with the stored proc. seems UTL_FILE can only save file within the its own platform instead of reaching the client's). and the same thing happens to TEXT_IO. so, the .txt file is still on the server and waiting for ur rescue. :-)

thanx!

rgds,
thenard

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 00:00:00 CEST

Original text of this message