Re: PL/SQL Recursion
From: Austin Moseley <\"moseba_at_audv55.aud.alcatel.com'>
Date: 1996/03/23
Message-ID: <4j00oc$dh_at_news01.aud.alcatel.com>#1/1
Date: 1996/03/23
Message-ID: <4j00oc$dh_at_news01.aud.alcatel.com>#1/1
hays_at_magicnet.net (Jeff Hays) wrote:
>Has anyone done recursive work with PL/SQL. My simple test functions work, but
>I don't seem to find any documentation from Oracle. Are there any pitfalls to
>be aware of.
>
Yes, very large rollback segments, esp if you are processing table(s). This can really hit other users, much like recursively sumbitted batch jobs on mainframes.
You might want to put arbitrary exits based on a count call.
Look at decode as well - to make the recursion tighter.
-Austin Received on Sat Mar 23 1996 - 00:00:00 CET