Hi,

One time only procedure is executed only once when the package is first invoked within the user session. The key word END is not used at the end of the one time only procedure.

Regards,

G.Kavitha

One time procedures is a Simple anonumus block in a package body which will not have an end keyword .  end for package will serve the both task.  this procedure is executed very first time when first call made to this package.

example:

create package body demo as
function show_num return number is
begin
return num;
end;
begin
num := 50;
end;
end demo;

 create or replace package body demo as
 function show_num return number is
 begin
 return num;
 end;
 begin
 num := 50;
 end demo;

And the primary purpose of one time procedure is for one time initialisation of package variables