View Full Version : SQL procedure

04-16-2011, 11:56 PM
I need some help creating a recursive plsql procedure that will take in an ID and return a SET OF ID'S

Old Pedant
04-17-2011, 12:00 AM
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.

04-17-2011, 12:19 AM
yea thats why im asking if anyone can help me create it or show me a similar example. I cant change the table.

Old Pedant
04-17-2011, 03:24 AM
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.