packages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: packages

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Germantown, MD
    Posts
    14
    what is the proper command and syntax to run a package once it has been compiled?

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    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

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    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
  •  


Click Here to Expand Forum to Full Width