PL/SQL: What is the maxiimum size of ARRAY OF RECORD
From: Claus <clkhm_at_hotmail.com>
Date: Mon, 1 Dec 2003 23:18:23 GMT
Message-ID: <3fcbcc9c$0$95005$edfadb0f_at_dread11.news.tele.dk>
Hi all,
END; Now the questions:
Date: Mon, 1 Dec 2003 23:18:23 GMT
Message-ID: <3fcbcc9c$0$95005$edfadb0f_at_dread11.news.tele.dk>
Hi all,
[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;
END; Now the questions:
[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