Hi,
I would say that it is really strange, I declared my varray as below:
type late_arr is varray(14) of number;
cur_late late_arr := late_arr();
when I try to assign value to the array using for loop it caused problem. This is the error msg.
Not Found
The requested URL /pls/prod_portal30/PORTALDEV.SAM_REPORT.show was not found on this server.
I tried to use
cur_late(1) := 2;
also generate same error.
Pls help.
p/s: I'm using the PL/SQL to create application in the Oracle Portal
and the Application Component item type is Dynamic Page.
Hi,
the problem has been solved by using :
cur_late.extend(1);
cur_late(1) := 2;
just curious to know why???
I have already specified its type of definition and its maximum size of the varray => type late_arr is varray(14) of number;
why we still need to use Extend method in order to assign value to the varray??? I'm not going to use more than the max size, why should I extend it??Doesn't the Extend Method is used for increasing the size of a collection.
Bookmarks