"ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu call ,pmuccst: adt/record) " 

Declare
    
Type Ty_tbl is table of Ty_rec
    Index by Binary_integer ;

Blk_Ty    Ty_Tbl;
Cnt number :=0;
t OMS_REQUIRED_TABLE.PROBLEM%type;
Begin
SELECT   /* +Parallel(d,4) */ c.ORDER_NODE_INDEX,c.ORDER_SEQ_ID,c.ORDER_NODE_ID,c.PARENT_NODE_INDEX,c.NODE_VALUE_TEXT,
        c.NODE_VALUE_NUM,d.NEW_TABLE_NAME,d.NEW_COLUMN_NAME, d.NEW_COLUMN_TYPE, d.NEW_COLUMN_SIZE,d.ATTRIBUTE_TYPE,
        c.DATA_DICTIONARY_ID,d.PROBLEM
        Bulk collect into Blk_Ty 
    FROM
    OM_ORDER_INSTANCE c INNER JOIN OMS_REQUIRED_TABLE d on c.ORDER_NODE_ID=d.ORDER_NODE_ID
    WHERE c.ORDER_NODE_TYPE NOT IN ('G','T')  ;
End;

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted
 *Action: