Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to initialize an array in PL/SQL?

How to initialize an array in PL/SQL?

From: <suisum_at_ecn.ab.ca>
Date: 2000/06/25
Message-ID: <39567ddc@ecn.ab.ca>#1/1

If I create a RECORD TYPE, then create a TABLE TYPE based on the RECORD TYPE, I have not problem to put the data in. But I have problem to re-initalize the TABLE TYPE.

DECLARE    TYPE t_abc_record IS RECORD

     (field_1   NUMBER,
      filed 2   NUMBER);

   TYPE t_table IS TABLE OF t_abc%ROWTYPE    INDEX BY BINARY_INTEGER;    v_abc_rec t_abc_record;
   v_abc_table t_table;

BEGIN    v_abc_table.field_1 := 1;
   v_abc_table.field_2 := 2;

   v_abc_table := NULL; (program crash)

END;

--
Best regards,
Received on Sun Jun 25 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US