SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transfer of file to different servers using Webutil

GarvJul 12 2010 — edited Jul 14 2010

Hi,

Currently I am using webutil_file_transfer.db_to_client_with_progress() to transfer a file to my local machine(Topaz/Vista clients). Till now, I hard coded the path as C:/Temp and this is where the file gets saved. Now I have to save the same file on some other server (*Citrix*) as well where drive 'C:/' is not accessible. There, I need to save the file in drive *'M:/'*. But then if harcode this, my Vista.Topaz clients will not be able to save the file. I tried to use dbms_system.get_env() to fetch the value of environment variable which i had planned to set up differently on different servers but this feature is available only in 10g. My applications are using *9i db*. Can you suggest any alternative.

Gaurav

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2010

Added on Jul 12 2010

#9i, #database, #oracle, #pl, #pl-sql, #plsql, #sql

5 comments

1,346 views