oracle8.1.6 select content_symlink.resolve( :id ) from dual select content_folder.get_index_page($parent_var) from dual select i.item_id id, content_item.get_path(i.item_id) path from cr_items i, cr_symlinks s where i.item_id = s.target_id and i.item_id = :original_id select parent_id, NVL(label, name) label, description from cr_items i, cr_folders f where i.item_id = f.folder_id and f.folder_id = :id