1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

call procedures in cycle

Discussion in 'SQL PL/SQL' started by ecivgamer, Jul 21, 2011.

  1. ecivgamer

    ecivgamer Active Member

    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    130
    Hi all,

    I've got some quantity of procedures in package

    procedure1
    procedure2
    ...
    procedureN

    I should call them in cycle instead of typing each of them manually.

    I know it's a bad idea to do something like this "dynamically". But it's technical task, not just my wish.

    Please, be so kind, suggest me correct syntax for doing that.
    Thanks ahead.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Explain in better detail what it is you want (need) to do.
     
  3. ecivgamer

    ecivgamer Active Member

    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    130
    Now everything works, thanks for attention.

     
  4. Addison_16

    Addison_16 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    u can use the looping structure to execute that