QUOTE (SteveC @ Aug 18 2008, 08:17 PM)
Thanks for providing your information in bits and pieces. Let's answer this incompletely a few more times until we have all of the relevant information from you, okay? You will need to use an external procedure call (e.g., Java) to write something on your client. Or, have the server write the file to a shared file system. What does on the client really mean? One of your local hard drives or somewhere on the NFS your client has access to?
I need to create a dir in my local hard disk.Because,server is not accessable by me.
My core objective :
I have data in varchar2 variable,it has huge length.So,i could not able to display using dbms_output.put_line due to stack overflow.I need to store this in my hard disk as a txt file.
Suggest me if any other ways to get back my data from varchar variable.
Thanks in advance.