The PL/SQL file I/O feature is available for both client side and server
side PL/SQL. The client implementation (text I/O) is subject to normal
operating system file permission checking, and it does not need any
additional security constraints. However, the server implementation might be
running in a privileged mode, and will need additional security restrictions
that limit the power of this feature.
Note:
The UTL_FILE package is similar to the client-side TEXT_IO package
currently provided by Oracle Procedure Builder. Restrictions for a server
implementation require some API differences between UTL_FILE and TEXT_IO. In
PL/SQL file I/O, errors are returned to you using PL/SQL exceptions.
"Brian Potter" <potterrb_at_mediaone.net> wrote in message
news:eD2G7.238$oM5.33882_at_typhoon.mw.mediaone.net...
> Hi,
>
> I would like to use DBMS_OUTPUT or UTL_FILE or some other package to write
> to a file on an Oracle client machine. I have a procedure right now in
the
> database (on a Sun server) that writes to a file in a directory on the Sun
> server. I would like to be able to write to a file on a Windows client
> machine when the procedure is invoked from a client app written in Oracle
> Forms 6.
>
> Does anyone know how to do this?
>
> Thanks,
> Brian
>
>
Received on Tue Nov 06 2001 - 22:36:20 CST
