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!

Calling PL/SQL procedures recursively??

382331Apr 1 2003 — edited Apr 2 2003
I'm attempting to use a stored procedure in a recursive fashion. Works fine when running in debug mode, but seems to have problems when running free.

Consider this procedure:

CREATE OR REPLACE PROCEDURE SpTstRecursive(
parOne IN INTEGER,
parTwo IN INTEGER) IS

localOne INTEGER;
localTwo INTEGER;

BEGIN
localOne := parOne;
localTwo := parTwo;

<Doing my stuff>;

SpTstRecursive(localOne, localTwo);

<Doing more of my stuff>;

END SpTstRecursive;

I was hoping to use recursive procedures and functions combined with DBMS_RANDOM functionality to generate random depth tree structures in my database.

Is this supposed to work??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2003
Added on Apr 1 2003
4 comments
9,381 views