创建存储过程出错，必须声明标识符

[wrq1994]

/*<TOAD_FILE_CHUNK>*/
CREATE OR REPLACE PROCEDURE SYMBOLS.GET_PROCESS (p_cursor out CURSOR_PACKAGE.p_cursor)IS

BEGIN
open p_cursor for
select* from fm_split_process order by process_seq_no asc;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END GET_PROCESS;
/



[Warning] ORA-24344: 成功, 但出现编译错误
1/45 PLS-00201: 必须声明标识符 'SYS.CURSOR_PACKAGE'
PL/SQL: Compilation unit analysis terminated
(2: 0): Warning: compiled but with compilation errors

[寡丶人]

这里的CURSOR_PACKAGE应该需要你自己去定义的，不是系统自带的存储过程。 重新定义一个CURSOR_PACKAGE.p_cursor应该就可以了。