René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Package initializer [Oracle PL/SQL]

A package initializer is executed at most once for a session. It is executed when the package is first accessed within that session. This is demonstrated in the following:
create or replace package pck_init_ex as

  procedure print(t in varchar2);

end pck_init_ex;
/
create or replace package body pck_init_ex as

  procedure print(t in varchar2) is begin
    dbms_output.put_line(t);
  end print;

  begin -- Here's the package initalizer
    print('Loaded');

end pck_init_ex;
/
Any session:
exec pck_init_ex.print('one');
Loaded
one
exec pck_init_ex.print('two');
two
Any other session:
exec pck_init_ex.print('three');
Loaded
three
exec pck_init_ex.print('four');
four