Re: read and write to textfiles on "local" box with PL/SQL?

what's so hard about a PRO*C (or COBOL or FORTRAN or...) program? Why not PERL? Do the logic in the PL/SQL and PRO*C for the I/O.

 Ed Prochak
 Magic Interface

(did somebody say some about the right tool for the job?)

"D. Motsiff" wrote:

> .
>
> i am actually trying to set up a series of SQL reports and PVCS tools
> for coworkers to run by themselves. In order to save my fellow
> cubemates from the 'ordeal" of having to copy the files from the
> remote database to their local drives after running every report, i
> wanted to save them directly to the local drives for them. ( i know,
> i know, what's so hard about a 'cp' command, right? <grin>)
>
> but i don't think its possible to do this without confguring the
> 'init.ora' file to mount the local drives as someone has mentioned. (
> i don't have permissions to do this, and if i did, it would surely not
> make my DBA too happy.)
>
> not too many other options, are there? maybe i could kick off a ftp
> script from a pl/sql procedure? is this possible from inside a
> pl/sql block?
>
> thanks for the responses, btw.
>
> On Wed, 26 Sep 2001 21:39:29 +0100, "Jonathan Lewis"
> <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> >
> >utl_file is run by the server-side executable,
> >and is designed to read and write only on
> >server-side directories (as specified in the
> >utl_file_dir in the init.ora).
> >
> >Would it be appropriate to tell the server
> >to mount your disks so that they appear
> >to be local to the server ? This might
> >fool Oracle.
Received on Thu Sep 27 2001 - 22:42:04 CDT