Help - Search - Members - Calendar
Full Version: Write into oracle client side file
Oracle DBA Forums > Oracle > Oracle Forum
Aruns
Hi,
I need to write into file which resded in local disk folder 'C\logfolder'


DECLARE
fhandler UTL_FILE.file_type;
BEGIN
fhandler := UTL_FILE.fopen ('C\logfolder', 'logfile', 'w');
UTL_FILE.putf (fhandler,'I am able to write into file');
END;

i get an error "Invalid file path'
How to write into file which resides in local disk (client side)(not in server side file).
Cannot make UTIL_parameter setting in init.ora since dont have previlage to do
dave
utl_file can only write to the database server, not to the client

your client program will have to read the data and write it out
Aruns
QUOTE (dave @ Feb 20 2008, 07:21 AM) *
utl_file can only write to the database server, not to the client

your client program will have to read the data and write it out

can you send links related to this topic for further guidance.I couldn't understand your point
dave
links to what? utl_file cannot write to the client machine, only the database server
Aruns
QUOTE (dave @ Feb 20 2008, 08:09 AM) *
links to what? utl_file cannot write to the client machine, only the database server

Links to write into client side file.
TEXT_IO package is available in oracle form ,but i need to write using procedure.
burleson
Hi,

>> I couldn't understand your point

You need to write to the file yourself, what's unclear about that?

>> i need to write using procedure.

Most folks use Javascript (or another client-side applet) for this:

http://download-west.oracle.com/docs/cd/B3.../javascript.htm

I would use the Oracle Javascript API:

http://forums.oracle.com/forums/thread.jsp...3&tstart=45
burleson
Also, here is a PL/SQL snippet that will write to a client PC:

http://dba-oracle.com/t_oracle:__write_a_f...a_client_pc.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.