-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|