Calling PL/SQL procedures recursively??
382331Apr 1 2003 — edited Apr 2 2003I'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??