8i中CONNECT_BY_PATH问题，求高手解

[stone100]

我在8i中，在PL/SQL里执行：
“select n_branch_no
,TO_NUMBER(SUBSTR(CONNECT_BY_PATH(n_branch_no, '/') || '/',2,INSTR(CONNECT_BY_PATH(n_branch_no, '/') || '/', '/', 1, 2) - 2 )) rootNo
from t_branch
where n_cancel_flag=0
connect by prior n_branch_no=n_up_branch_no start with n_up_branch_no in(156,157,158)“

没有问题，但这个语句放到存储过程中时，在编译存储过程时报错：
Compilation errors for PROCEDURE STT_INCM.P_ALL_REPORT

Error: PLS-00201: identifier 'POST_AUTHENTICATION.CONNECT_BY_PATH' must be declared
Line: 34
Text: select n_branch_no,TO_NUMBER(SUBSTR(CONNECT_BY_PATH(n_branch_no, '/') || '/',2,INSTR(CONNECT_BY_PATH(n_branch_no, '/') || '/', '/', 1, 2) - 2 )) rootNo

Error: PL/SQL: SQL Statement ignored
Line: 18
Text: insert into tmp_brh_report(n_pc_no,n_operation_no,n_brh_no,n_mny)


求解决办法