Isso foi dificil de fazer, ate mesmo porque nao se encontram exemplos dentro da documentacao da oracle, eu acabei encontrando em uma pagina do portal que retornou o erro com essa consulta de brinde.

Retornar a URL a partir das tabelas do portal.

Fazer o login primeiro para a consulta funcionar.

begin
portal.wwctx_api.set_context(‘andre.rocha’, ‘cds123’);
end;

select * from (
SELECT caid,
id,
display_name,
— SYS_CONNECT_BY_PATH(a.DISPLAY_NAME),
SYS_CONNECT_BY_PATH(a.CAID || ‘,’ || a.ID || ‘,’ || a.NAME,’;’) as path,
level,
replace(SYS_CONNECT_BY_PATH(‘/’ || a.NAME, ‘;’), ‘;’, null) as URL
FROM Portal.wwsbr_all_folders a
WHERE
a.CAID = P_PGGROUPID
AND a.LANGUAGE = Portal.wwctx_api.get_nls_language()
AND a.TYPE_ID in (SELECT DISTINCT
tp.id
FROM Portal.wwsbr_folder_types tp
WHERE tp.NAME NOT IN (‘categoryperspectivepage’, ‘nav’, ‘search’, ‘tab’))
START WITH a.PARENT_ID = 1
CONNECT BY PRIOR a.ID = a.PARENT_ID
AND PRIOR a.CAID = a.CAID
AND PRIOR a.LANGUAGE = a.LANGUAGE) a, portal.WWSBR_ALL_CONTENT_AREAS b
WHERE a.caid = b.id
AND a.id = P_PAGE_ID;

logicamente, remova os parametros ou substituia o P_PAGE_ID..