Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Thu Oct 18 2001 - 05:14:00 CDT
![]() |
![]() |