Home » SQL & PL/SQL » SQL & PL/SQL » DBMS.UTL_FILE Doubt
DBMS.UTL_FILE Doubt [message #39886] Wed, 21 August 2002 07:13 Go to next message
Ravichandran
Messages: 4
Registered: January 2002
Junior Member
Hai
In my office oracle 8i server has been installed in win NT platform and oracle client is installed in 98 systems,i cannt use dbms.utl_file package, invalid path error is coming,the reason given in doc is utl_file_dir constant should be initilised in init.ora file,it is in server,how can i set my client systems directory,
Is there any way to set client dir without specifying in init.ora.
Re: DBMS.UTL_FILE Doubt [message #39889 is a reply to message #39886] Wed, 21 August 2002 08:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you specify utl_file_dir it will be effective only
in server ( where the databse is running).
and NOT in the client machine.
Re: DBMS.UTL_FILE Doubt [message #39957 is a reply to message #39886] Wed, 28 August 2002 01:06 Go to previous message
SEMANTICA
Messages: 9
Registered: July 2002
Junior Member
You may want to take a look at PL/File :

PL/File offers advanced file-, directory- and ZIP file functionality from within Oracle. Through PL/SQL these functions can be called in any Oracle application.
It makes no difference if these files are located on the database machine or other machines. By using the J2EE architecture and Oracle, PL/File guarantees
platform independence.

www.plfile.com

Kind regards,
www.semantica.com
Previous Topic: CONVERSION.
Next Topic: check if folder exist
Goto Forum:
  


Current Time: Thu Apr 25 06:28:30 CDT 2024