HI,

In our pl/sql procedure we need 500 local variables(datatypes are different) at a time.. Is it better to use variables or we can use use a table or a varray..

a1 number:=0;
..
a19 date;
..
a89 varchar2(20);
...
a500 number:=0;

***************************************
or we can use

table t1 is type of number(100);
table t2 is type of varchar2(100);
table t3 is type of date;

o1 t1;
02 t2;
03 t3;
******************************************
which one is better in terms of performance...

regards
sam