configuration management

From: bdj <>
Date: Tue, 14 Dec 2004 20:27:33 +0100
Message-ID: <41bf3e85$0$220$>

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 := '';
   ipnr := '';
  end if;
end; -- package end!

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

Bjørn Received on Tue Dec 14 2004 - 20:27:33 CET

Original text of this message