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
