PL/SQL (MOSC)

MOSC Banner

How to (re)initialze a Collection Table

edited Mar 13, 2012 3:13PM in PL/SQL (MOSC) 4 comments
I need to re-initialze the table in the following code sample. The rows in the table are retaining subscript data, so I need the collection cleared before the next population of data.

Procedure Main_Procedure is

i_bom_component_tbl   Bom_Bo_Pub.Bom_Comps_Tbl_Type := bom_bo_pub.g_miss_bom_component_tbl;
                    Number :=0;
v_Bill_Sequence_id    Number :=0;

Begin

   
For BOM_Rec in BOM_Csr(v_Bill_Sequence_id) Loop

        v := v + 1;

      -- Component detail data assignments. 
        i_bom_component_tbl(v).Transaction_Type :='UPDATE';
        i_bom_component_tbl(v).Start_Effective_Date := BOM_REC.Effectivity_Date;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center