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!

Recursive records in PL/SQL

443806May 30 2005 — edited Jul 19 2012
Hi,

Since PL/SQL supports recursion in functions, it seemed reasonable to be able to define records recursively too. That is, one of the fields in the record would be that record type itself. But it does not seem to work.

I am curious to know how you would build say, a tree in a PL/SQL data structure. Or is that stretching PL/SQL way too much?

Thanks,

Regards,

Srini
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2012
Added on May 30 2005
6 comments
1,369 views