PL/SQL: What is the maxiimum size of ARRAY OF RECORD

[Quoted] Lets say I have the following PL/SQL block: (I know the code is not correct, its just to illustrate)

DECLARE
[Quoted]      CURSOR c IS select * from EMP;

[Quoted]      TYPE emprecs IS ARRAY OF EMP%TYPE INDEX BY BINARY_INTEGER;

     myrecs emprecs;

BEGIN

[Quoted]       OPEN c;
      FETCH c INTO myrecs;
      CLOSE c;

[Quoted]       FOR myrecs.first TO myrecs.last LOOP
            do something
      END LOOP;

[Quoted] What is the memory limitation on the size of the "myrecs" array?

[Quoted] Which init.ora parameter controls the maximum size?

[Quoted] Where is "myrecs" actually allocated, - in the SGA or PGA?

[Quoted] What exception will I get if the maximum size is exceeded?

[Quoted] Hope you can help me out.

Cheers
Claus Kjaergaard Received on Tue Dec 02 2003 - 00:18:23 CET