When querying from the DB you have to use some complicated SQLs to accomplish this.
Note: The t_crs is a ref cursor that is declared any pkg spec of your util package. It is declared like this: type t_crs is ref cursor;
For the testcase above getting path is something like this:
And the output will be like this: