How to fix the Oracle error ORA-06531: Reference to uninitialized collection?

In this post, you’ll learn more about the Oracle ErrorORA-06531: Reference to uninitialized collection with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-06531: Reference to uninitialized collection

Reason for the Error ORA-06531: Reference to uninitialized collection

An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without the collection having been initialized.

How to fix the Error ORA-06531: Reference to uninitialized collection ?

You can fix this error in Oracle by following the below steps

Initialize the collection with an appropriate constructor or whole-object assignment.