CREATE OR REPLACE function func_test(AgentCode in Varchar2)
return number is
SellCount number;
begin
select count(cAgentCode) into SellCount from tbAgentMonthReport where cAgentCode=AgentCode;
return SellCount ;
END func_test;
/CREATE OR REPLACE PROCEDURE test_func as
tmpVar NUMBER;
EXECSQLCOUNT varchar2(200);
BEGIN
tmpVar:=0;
EXECSQLCOUNT:='func_test('''||'08010015'||''')';
--tmpVar :=func_test('08010015');
EXECUTE IMMEDIATE EXECSQLCOUNT INTO tmpVar;
tmpVar:=5;
END test_func;
/
EXECUTE IMMEDIATE EXECSQLCOUNT INTO tmpVar;
执行不过去
return number is
SellCount number;
begin
select count(cAgentCode) into SellCount from tbAgentMonthReport where cAgentCode=AgentCode;
return SellCount ;
END func_test;
/CREATE OR REPLACE PROCEDURE test_func as
tmpVar NUMBER;
EXECSQLCOUNT varchar2(200);
BEGIN
tmpVar:=0;
EXECSQLCOUNT:='func_test('''||'08010015'||''')';
--tmpVar :=func_test('08010015');
EXECUTE IMMEDIATE EXECSQLCOUNT INTO tmpVar;
tmpVar:=5;
END test_func;
/
EXECUTE IMMEDIATE EXECSQLCOUNT INTO tmpVar;
执行不过去
SQL> create procedure p1 as
2 begin
3 dbms_output.put_line('111');
4 end p1;
5 /过程已创建。
SQL> declare
2 s varchar2(100);
3 begin
4 s:='begin
5 p1;
6 end;';
7 execute immediate s;
8 end;
9 /
111PL/SQL 过程已成功完成。SQL>