Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the life cycle ,Scope of PL/SQL Collection or PL/sql Array

Pritam DasMar 4 2023

Hi Expert,

I was wondering to know the below points for PL/SQL Collection.

1)How Memory management is done for PL/SQL Collection and when the memory is being destroyed for the allocated memory

2)What is the scope of PL SQL collection e.g. If we initialize an array inside one cursor loop and can we access the same array elements inside another cursor loop.

It would be great if i got the answer with some explanation as I'm beginner in Pl/sql

Regards,

Pritam

Comments
Post Details
Added on Mar 4 2023
2 comments
183 views