Can i write to a file on local machine (client side) from blob to a text file /gif/etc in pl/sql programmming
If its so can u give me an example
Thanks in advance
you can try the package UTL_FILE.
I think shes talking about writing to client hard disk and not the server.
Is that possible using UTL_FILE ?
if we can map the client hard drive to the server.
Nope you Cannot do it in pl/sql with utl_file package .You should do it in some client program.
for example if your using sql * plus try spool filename .If you are using developer 2000.Then there is something else.
Pl/sql was not designed to do client side file-IO
Even i was thinking the same hrishy......
no way we can write to client side using pl/sql.
Can't we try this by writing a JAVA CLASS and upload into Oracle.
Sorry press the submit button before finishing the whole stuff.
Can't we try this by writing a JAVA CLASS which will write to the client machine using fileoutputstream. Read using fileionputputstream
Do u mean this...
If its a windows 200 server
The client drive must be a domain share on the db server.
Utl_file parameter needs to be set to '*'.
theres security issue with parameter setting to '*'
Anyone has done this kinda stuff.
i have not tried.
but i hope we can map and do.
Click Here to Expand Forum to Full Width