ORACLE存储过程中如何调用自己写的存储过程
在我写的ORACLE存储过程中,需要调用之前写好的存储过程。
请熟悉的朋友帮忙指点一下,怎么处理
CREATE OR REPLACE PROCEDURE traph_JOB IS
BEGIN
declare
TRAPHNAME VARCHAR2(200);
CURSOR c_route IS
SELECT label_cn from traph a where CHECK_FLAG =2;
BEGIN
OPEN c_route;
LOOP
FETCH c_route INTO TRAPHNAME;
EXIT WHEN c_route%NOTFOUND;
execute immediate TRAPH_ROUTE (TRAPHNAME);
-----------------------------------------------
此处显示如下错误
Compilation errors for PROCEDURE GDRES.TRAPH_JOB
Error: PLS-00222: no function with name 'TRAPH_ROUTE' exists in this scope
Line: 14
Text: execute immediate TRAPH_ROUTE (TRAPHNAME);
Error: PL/SQL: Statement ignored
Line: 14
Text: execute immediate TRAPH_ROUTE (TRAPHNAME);
------------------------------------------------
END LOOP;
CLOSE c_route;
END;
END;