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
Post a Comment