OraFAQ Forum: SQL & PL/SQL » Avoiding Hardcoding folder paths

Home » SQL & PL/SQL » SQL & PL/SQL » Avoiding Hardcoding folder paths

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Avoiding Hardcoding folder paths [message #180996]

Thu, 06 July 2006 04:17

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

There is a procedure which creates a file in a particular location in the remote server (Unix), at present the folder path is hardcoded,

Now the problem is the DB instance is being moved to another physical location, this may happen in future also, so what is the method to avoid hard coding the folder path in the procedure, what is a better work around for this one?

Any body who have come across the same and have a solution, kindly help me.

Thanks,

NN

Report message to a moderator

Re: Avoiding Hardcoding folder paths [message #181007 is a reply to message #180996]

Thu, 06 July 2006 04:54

himang
Messages: 282
Registered: March 2005
Location: Bangalore

Senior Member

Why not pass the folder path as a parameter to the procedure? So whenever it changes, you just need to change it from calling application....

Regards
Himanshu

Report message to a moderator

Re: Avoiding Hardcoding folder paths [message #181243 is a reply to message #180996]

Fri, 07 July 2006 11:09

stevebooth
Messages: 14
Registered: June 2006
Location: Pewaukee, WI

Junior Member

Or put it in a table...

Report message to a moderator

Re: Avoiding Hardcoding folder paths [message #186712 is a reply to message #180996]

Wed, 09 August 2006 03:35

janny
Messages: 5
Registered: August 2006

Junior Member

There is a possible way.
Create a directory as shown,

CREATE DIRECTORY --directory_name-- AS '--file_path';

This directory can details can be viewed through DBA_DIRECTORIES.

Now call the directory_name as followed,

utl_file.fopen(--directory_name--,--file_name--,--mode--);

Better to store the directory_name in a constant variable.
If there is any change in the file_path, just alter the directory with the new path. You can use,

CREATE OR REPLACE DIRECTORY --directory_name-- AS '--new_file_path--';

Try this...you will get things done.... Cool

Regards
Justin

Report message to a moderator

Previous Topic:	query on triggers... reply asap...
Next Topic:	New install of 9i, unable to login

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 18:07:35 CST 2024