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

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.

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

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