That depends on what you actually want to achieve. You can use SQL*Plus
and SPOOL the output into the local file or you can write your own program
that will call a PL/SQL filling up some host var, array or temporary table, fetch
the data and write it to the local file. Please be more specific about what exactly
you are trying to do. :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"EP" <ep_at_plusnet.pl> wrote in message news:a4rkuj$aub$1_at_news.tpi.pl...
> Is there any possibility of generating a text file on the Oracle Client from
> PL/SQL or Forms ? (utl_file_dir refers to the server directory, so it's
> useless).
>
> TIA
>
> EP
>
>
Received on Mon Feb 18 2002 - 13:53:21 CST
