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
 

Reply via email to