Thursday 9 May 2013

What are disadvantage of bulk collection?

Using the BULK COLLECT clause in PL/SQL implies following restrictions:
1.     We cannot bulk collect into an associative array having a string type for the key.
2.     BULK COLLECT clause can be used only in server-side programs (not in client-side programs) else, error is reported that it is not supported in client-side programs.
3.     Collections should be used as target variables listed in a BULK COLLECT INTO clause.
4.     Composite targets (such as objects) cannot be used in the RETURNING INTO clause else error is reported for feature with RETURNING clause.
5.     Multiple composite targets cannot be used in the BULK COLLECT INTO clause when implicit data type conversions are needed.
6.     When an implicit data type conversion is needed, a collection of a composite target (such as a collection of objects) cannot be used in the BULK COLLECT INTO clause.

No comments:

Post a Comment