|
Thanks Forrest
----- Original Message -----
Sent: Thursday, October 18, 2001 5:45
PM
Subject: RE: Initialize Varrays
gt(gtcount):=''; should work as well as
gt(gtcount):=NULL;
as
long as gtcount is valid.
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
|
