Subject Recursive procedure
Author Agung Wibudi
Hi All,
I 've problems with sorting data that implement with stored procedure.
The Store procedure is Recursive's stored procedure.
Structure data in table like :
field1 ID CHAR(2),
field2 Parent_id char(2) (Child of field1),
field3  Level integer (The level Of record , 1 is parent, 2 is child, etc)

I want to sort that table like parent child method or (Tree View).

I always failed to get the results (returns in SP always NULL use Suspend).

How to get the output of the child record ;