Hello,
I created a package that compiled perfect but when I executed I'm getting an error of type uninitialised collection because I'm using a varray that isn't initialised. I can't initialised the varray because it has too many elements and if I do initialised only a couple of elements I get a run time error Subscript beyond count.
Thanks for helping.
Ibra

[QUOTE][SIZE=1]Originally posted by ibra
When you declare the VARRAY you can initialise it like this:

DECLARE
TYPE t IS VARRAY(100) OF NUMBER;
var t := t();
...

You can then use the EXTEND method to make all the subscripts valis:

BEGIN
var.extend(100);

You can now access any element of var.

hello Andrew
Thanks a lot for your help that was the peace of the puzzle and in top of it I'm a new pl/sql prog
Ibra
[QUOTE][SIZE=1]Originally posted by andrewst

That's OK. I can't say I really understand WHY you have to "extend" a VARRAY just to use the elements you already declared!

You right andrew I don't understand either.
I have another question because now I'm getting an error of type
ERREUR à la ligne 1 :
ORA-01840: input value not long enough for date format
ORA-06512: at "INTRA.OPR_PCK_CATIT", line 160
ORA-06512: at line 1
and actually the line his refering too is like this
FETCH C_initFldInf INTO A,B,C,D,E,F,G,H,I;
Thanks

There must be a TO_DATE in the select statement of that cursor on a VARCHAR2 value that is not in the right format.

Example:

SQL> select to_date('01-JAN','DD-MON-YYYY') from dual
2 /
select to_date('01-JAN','DD-MON-YYYY') from dual
*
ERROR at line 1:
ORA-01840: input value not long enough for date format