Friday 25 May 2012

What is a One-Time-Only procedure and how is it declared within a package? | PL SQL

 A One-Time-Only procedure is executed only once, when the package is called for the first time. While declaring a One-Time-Only procedure the keyword END is not used at the end of the one-time-only procedure however, the procedure uses the package body's END clause, as the procedure's code is placed at the bottom of the package body.