Thanks for the question, Alok.
Asked: January 26, 2017 - 9:05 am UTC
Last updated: January 26, 2017 - 1:55 pm UTC
Version: Latest
Viewed 1000+ times
You Asked
Hello Tom,
I have to call a procedure inside a procedure more than 35k times. Can I do this using a normal loop or bulk collect-forall will be better approach?
Thanks in advance.
and Chris said...
Why on earth do you have to call a procedure 35,000 times?!
Yes, you could do this with a normal for loop. But this sounds like classic row by super slow row processing. Particularly as you've asked about bulk collect-forall, suggesting this is data driven...
So first question is:
Can you do whatever this is in a single SQL statement?
If no, does bulk processing help?
If still no, then go for a "normal" loop.
To provide any more meaningful guidance, you'll have to give us a lot more details about what you're doing...
Is this answer out of date? If it is, please let us know via a Comment