oracle - executing a procedure inside a package -


there package abc , many procedures inside it. want execute single procedure inside (say xyz). used below commands

begin abc.xyz; end; 

i not able run same. can 1 getting unexpected symbol "begin" error

create package specification :

create or replace package pkg procedure xyz; end; 

create package body :

create or replace package body pkg procedure xyz dbms_output.put_line('hi'); end end; 

executing

exec pkg.xyz 

or

begin pkg.xyz; end; 

now, verify code , see have done wrong in code.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -