3 Replies Latest reply: Jul 28, 2008 1:49 AM by 646490 RSS

    ORA-06531: Reference to uninitialized collection

    433024
      Hello Friends,

      I am facing above problem. My procedure is accepting a table type.
      I am checking whether it has records using COUNT method. But it’s throwing above error. How should I prevent this error?
      Following is the structure of my object & table type.

      CREATE OR REPLACE TYPE OBJ_GROUP
      AS OBJECT
      (
      GRP_ID NUMBER,
      GRP_NAME VARCHAR2(100)
      )
      /

      CREATE OR REPLACE TYPE TBL_GROUP
      AS TABLE OF OBJ_GROUP
      /


      Thanks,
      RD