Re: Initialize Varrays

Thanks Forrest
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=Forrest.Payne_at_Cinergy.COM href="">Payne, Forrest To: <A title=ORACLE-L_at_fatcity.com href="">Multiple recipients of list ORACLE-L

  Sent: Thursday, October 18, 2001 5:45   PM
  Subject: RE: Initialize Varrays   

  <SPAN
  class=225201411-18102001>gt(gtcount):='';  should work as well as   gt(gtcount):=NULL;
  as
  long as gtcount is valid.   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Gavin D'mello     [mailto:gavin_d_at_tis.co.in]Sent: Thursday, October 18, 2001 7:00     AMTo: Multiple recipients of list ORACLE-LSubject:     Initialize Varrays
    Hi,
        I am working on

    Varrays in PL/SQL and till date the documentation provides a detailed     description on how to create and initialize Varrays. However, it does not     state the fact that when the Varray is extended, the new element is null and     so any attempt to insert values into it, results in a 'Subscript beyond     count' error. This basically boils down to the new element not being     initialized. this is the point where I am stuck.
 
 

    CREATE TYPE taxonomy AS VARRAY(5) OF     VARCHAR2(40);
 

    gt taxonomy := taxonomy('temp');
 

    gt.extend(1);
 

    gt(gtcount) := ' '; -- results in an error.
 

    Can Anyone tell me how do i initialize the new element of     the varray ?
 

    Thanks,
 

    Gavin
 
Received on Fri Oct 19 2001 - 00:18:00 CDT