Skip to Main Content
  • Questions
  • Triggering Package in different session

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Raja.

Asked: December 07, 2020 - 12:31 pm UTC

Last updated: December 08, 2020 - 5:45 am UTC

Version: 12C

Viewed 1000+ times

You Asked

Hi Experts, I meed to know is there any way we can trigger same package stored procedure for 100 inputs in different session at once through some block. Please let me know.

Say for example, i am getting some 1000 batches in a loop and triggers that package stored procedure 1000 times sequential. Instead of that, let’s span 1000 call to that package stored procedure at once in different session.

Thanks,
Raja

and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library