SQL procedure

I need some help creating a recursive plsql procedure that will take in an ID and return a SET OF ID'S

The best way to do this is undoubtedly via a stored procedure.

Even better is to rebuild your table with a "path" column that will allow direct queries to find most anything.

yea thats why im asking if anyone can help me create it or show me a similar example. I cant change the table.

Well, this is the MySQL forum, and few (if any) will know PLSQL. You'd be much better off finding an Oracle-specific forum.

I can write in MySQL and SQL Server, but I've never created SPs in Oracle.