Home » SQL & PL/SQL » SQL & PL/SQL » Disadvantages of Bulk Collect
Disadvantages of Bulk Collect [message #223671] Sat, 10 March 2007 04:04 Go to next message
parlovi
Messages: 6
Registered: February 2007
Location: BANGALORE
Junior Member
Guys,

Recently I came across a situation to use BULK COLLECT.
This improved execution time of a batch job.

But I would like to know
Are there any kind of disadvantages associated with using BULK COLLECT INTO ?
Can anyone point me to the link on advantages/disadvantages comparison of using BULK COLLECT ?


Appreciate you of helping on this.

Thx,
P
Re: Disadvantages of Bulk Collect [message #223706 is a reply to message #223671] Sat, 10 March 2007 10:04 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Advantages/disadvantages over what?

If dealing with a large number of columns it can become a pain to code and maintain due to the fact that FORALL (assuming that is also part of the solution) cannot handle PL/SQL records (though it can handle object types, which allows a workaround, sort of).
Previous Topic: Error PLS-00201:SYS_REFCURSOR must be declared
Next Topic: Exit from a sql script based on condition
Goto Forum:
  


Current Time: Fri Dec 09 23:36:15 CST 2016

Total time taken to generate the page: 0.09507 seconds