How can I declare a local cursor within a recursive function? What this
function does is it clean up a hierarchy.

I know in SQL Server it is DECLARE xxx CURSOR LOCAL FOR ....

, but for Oracle I don't know it.

Could someone please help me?

Thanx,
Alexander

You could declare a dynamic cursor like this:
cursor name(variable varchar2) is
select whatever you want
from table
where columnname=(variable);

so you could call the function recursively and tranfer the parameter.

"Alexander Pino" <Alexander.Pino (AT) cea-int (DOT) com> wrote