我这样子写怎么不行?
create or replace procedure Cp_UserCallOutFinish
is
begin
...
exec c_test.cp_calloutcount;
...
end Cp_UserCallOutFinish;
但是我在SQL plus中运行
exec c_test.cp_calloutcount;又能通过?
谢谢!·
...全文
844打赏收藏
怎么样在存储过程中调用存储过程?
我这样子写怎么不行? create or replace procedure Cp_UserCallOutFinish is begin ... exec c_test.cp_calloutcount; ... end Cp_UserCallOutFinish; 但是我在SQL plus中运行 exec c_test.cp_calloutcount;又能通过? 谢谢!·
CREATE OR REPLACE PROCEDURE MIS.CHECK_SMT_EMP_LIGHT (STATION_NUM in varchar2,MACHINE in varchar2,
PPN in varchar2,VER in varchar2,DATA in varchar2,
LOC in varchar2,KPN in varchar2,SN in varchar2,
Line in varchar2,RES out varchar2) IS
C_EMP_ID VARCHAR2(25);
C_OUTPUT varchar2(64);
BEGIN
SELECT EMP_NO INTO C_EMP_ID
FROM SFIS1.C_EMP_DESC_T
WHERE EMP_NO = DATA AND ROWNUM = 1;