PL/SQL (MOSC)

MOSC Banner

need a small confirmation about how this package is executing

edited Dec 25, 2013 11:15PM in PL/SQL (MOSC) 4 commentsAnswered ✓
 Hi to all,
I have a package with two procedures defined in that and tow anonymous blocks
while i am executing that procedure from package only one time i am getting out put and if i ran the same second time the anonymous block is not getting executing.
if i open the another session also only one time is executing and if i run the second time the same no out put is comming.

create or replace package packtwo is
procedure p1 ;
procedure p2;
end;

create or replace package body  packtwo is
procedure p1  is
begin
dbms_output.put_line('From procedure one');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center