Can any one tell me how can I writh to a local file (C:/my_file.txt) from a procedure. I need to create sql statments and store them in a file for later execution.

I need to do this into a LOCAL file so I don't think that I can use UTL_FILE, is there any way to spool from a proc to a file??? or any other way to do this???

Thanks.