what is the proper command and syntax to run a package once it has been compiled?
Printable View
what is the proper command and syntax to run a package once it has been compiled?
Depend what you have in Package. But one thing sure, to use any component from a package you need to use a DOT Notation. Let's say you have a package named mypack and have one procedure named myproc .. To execute this Procedure you can run like
Exec mypack.myproc;
or
Begin
mypack.myproc;
end;
/
Hope this will help.
If you have any parameters for those functions and procedures, you need to give those Param as well just like stand alone Procs and Functions.
Thanks
As O8 stated, all that is necessary is to use dot notation. Then access any component of your package as normal, whether it be a memory structure, function or procedure:
SQL> exec mypackage.myproc;
SQL> select mypackage.myfunc(valuetopassin) from dual;
SQL> exec dbms_output.put_line(mypackage.mymemoryvar);
[Edited by kmesser on 04-29-2001 at 09:38 AM]