Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    76

    Question Unanswered: procedures inside a package

    I have 48 procedures sitting in a PL/SQL package. when I execute the package I have to select one procedure at a time to get it executed. What could I do to execute the package once and get all the procedures executed at the same time sequencially.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: procedures inside a package

    A package is just a bag of routines and stuff, somewhat like a library. You cannot execute a package, only the procedures within it.

    You need to write another procedure, or anonymous PL/SQL block, like this:

    BEGIN
    pkg.proc1;
    pkg.proc2;
    ...
    pkg.proc48;
    END;
    /

  3. #3
    Join Date
    Nov 2003
    Posts
    76

    Re: procedures inside a package

    Thank you very much

Posting Permissions

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