Results 1 to 3 of 3

Thread: Oracle -- Executing a Package

  1. #1
    Join Date
    May 2003
    Posts
    2

    Question Oracle -- Executing a Package

    Is it possible to execute a package at one time without having to call its subelements one at a time?

    I know you can do something like this:
    execute package.proc;

    but
    can you just say:
    execute package

    if all the procedures don't have any parameters?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    I don't think so.

    The purpose of creating a package is to group similar procedures. If want to run all then you may create just one procedure with the text of all procedures in the package.

  3. #3
    Join Date
    May 2003
    Posts
    2
    Yes, thank you for validating my sanity. That's what I thought -- but I wanted to run it through others just in case my understanding was incorrect.

    Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •