一个既可以传参,又可以输出值的存储过程的执行:
CREATE OR REPLACE PROCEDURE P_YXGL_DXHYXSJ(strSBID VARCHAR2,strBeginTime VARCHAR2,strEndTime VARCHAR2,ReturnValue out int) IS
begin
……
end P_YXGL_DXHYXSJ;
执行方法如下两种:
1、在sql窗口中执行:
declare
outp number;
begin
P_YXGL_DXHYXSJ(‘14016531’,’2017-04-23 10:25:58’,’2017-07-23 10:26:26’,outp);
dbms_output.put_line(outp);
end;
2、在command窗口中执行:
SET SERVEROUTPUT ON
VARIABLE outp NUMBER;
EXEC P_YXGL_DXHYXSJ(‘14016531’,’2017-04-23 10:25:58’,’2017-07-23 10:26:26’,:outp);
print outp;