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

One time procedure Its actually not a procedure but its called as one time procedure Why because this used to initialize variable calling function or procedure once the scope of package for user session.

This can be defined like this..
Package Body A
a number;


Proc a;

Proc b;

begin----End of one time procedure should be end of package body
a: 10;
End;