Created by
Jonathan Hult
| create or replace
PROCEDURE GET_FOLDER_PATH (
collection_id IN NUMBER
)
IS
new_collection_id NUMBER;
parent_id NUMBER;
path VARCHAR2(256);
complete_path VARCHAR(3000);
BEGIN
parent_id := 1;
complete_path := '';
new_collection_ID := collection_id;
WHILE parent_id NOT LIKE -1
LOOP
SELECT dparentcollectionid, dcollectionname INTO parent_id, path FROM collections WHERE dcollectionid = new_collection_id;
complete_path := path || '/' || complete_path;
new_collection_id := parent_id;
END LOOP;
DBMS_OUTPUT.PUT_LINE('/' || complete_path);
END GET_FOLDER_PATH;
|