470,586 Members | 1,392 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

configuration management

Hello out there!
I wish to make package self-initializing, dependent of the environment
(production / test)
Is following a good design pattern?:

Package body my_ftp
ipnr varchar2(100);

-- some procedures and functions

begin -- begin block in package body!
if this_is_production then
ipnr := 'external.domain.com';
ipnr := 'internal.domain.com';
end if;
end; -- package end!

The begin-block will only be executed the first time I use something in the
package in the session.

Jul 19 '05 #1
0 1979

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Serge calderara | last post: by
reply views Thread by Vish | last post: by
2 posts views Thread by Terry Holland | last post: by
reply views Thread by Shaun Ram | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.