-
clarification
Hi,
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
Anupama
anu
-
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 ?
Srini
-
if we can map the client hard drive to the server.
-
Hi Anu
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
regards
Hrishy
-
Even i was thinking the same hrishy......
no way we can write to client side using pl/sql.
Srini
-
Can't we try this by writing a JAVA CLASS and upload into Oracle.
Cheers!
OraKid.
-
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
Cheers!
OraKid.
-
Rajab
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.
Srini
-
i have not tried.
but i hope we can map and do.
-Raja
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|