Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> configuration management

configuration management

From: bdj <B.D.Jensen_at_gmx.net>
Date: Tue, 14 Dec 2004 20:27:33 +0100
Message-ID: <41bf3e85$0$220$edfadb0f@dread11.news.tele.dk>


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);

begin -- begin block in package body!
  if this_is_production then
    ipnr := 'external.domain.com';
  else
   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.

Greetings
Bjørn Received on Tue Dec 14 2004 - 13:27:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US