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;