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

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

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.

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

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