Re: DBMS_ output.put_line ERROR

On Wed, 22 Aug 2001 12:18:02 GMT, "Scott Mattes" <ScottMattes_at_yahoo.com> wrote:

>responding to your question). The problem with this is that the file is
>created on the server, so you need access to whatever system that is on and
>rights to view files in the directory where the DBA has established
>permission to write those files.

Or you make the output folder for utl_file a shared folder and map it to the client?

And if the volume is not too big, I suppose output could be loaded to a table in memory in PL/SQL (TYPE TABLE), then that table traversed and returned to the client with a cursor REF. I've seen an example of this somewhere, but can't remember the details. Can look it up if u interested.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Aug 22 2001 - 08:07:42 CDT