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
Messages: 6
Registered: February 2007
Junior Member

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.

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: 1642
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: VIEW
Next Topic: Copy long raw to long raw from pl sql
Goto Forum:

Current Time: Sun Aug 20 12:31:58 CDT 2017

Total time taken to generate the page: 0.04366 seconds