在我写的ORACLE存储过程中,需要调用之前写好的存储过程。
请熟悉的朋友帮忙指点一下,怎么处理
CREATE OR REPLACE PROCEDURE traph_JOB IS
BEGINdeclare
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_JOBError: 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;
请熟悉的朋友帮忙指点一下,怎么处理
CREATE OR REPLACE PROCEDURE traph_JOB IS
BEGINdeclare
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_JOBError: 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;
解决方案 »
- oracle中用户创建了角色,那么这个角色只有这个用户可以将它授权给别人么?
- oracle按要求查询,高分相送
- 求一段SQL文(不好描述,请进去看)
- 关于往正在运行的数据库(test)中导入aa.dmp的问题
- 怎么用SQL实现日期区间遍历每天数据?
- 安装oracle的问题
- Execute immediate 晕透了:(
- 这个触发器如何写
- 如何查看一个表的建立时间和修改时间
- 怎样删除用'alter tablespace users add datafile 'c:\...\users02.dbf' size 1000M autoextend on;'加的数据库文件?
- sql case 查询
- 关于游标打印的问题!
直接调用 写名字 参数 有返回值的用变量接收就行了~
http://apps.hi.baidu.com/share/detail/23314940