Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a file on the client

Re: Writing to a file on the client

From: Ron Reidy <rereidy_at_indra.com>
Date: Tue, 06 Nov 2001 21:30:09 -0700
Message-ID: <3BE8B8D1.B313554D@indra.com>


Brian Potter wrote:
>
> 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

DBMS_OUTPUT and UTL_FILE are invoked from the RDBMS engine. Unless the instance is running on the same machine as the client, I don't think you can do this. Sounds like user-exit time to me.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Tue Nov 06 2001 - 22:30:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US