oracle 存储过程中调用存储过程

A,较sql server中区别 : 
1,无exec
2,无output
3,添加()
B,oracle存储过程的入参
1,纯输入参数可以引用其值,但不可以赋值
 解决:建立本地参数暂存其数据,然后操作本地参数
2,输出参数可赋值,可引用

CREATE OR REPLACE PROCEDURE P_AM_WOSORD_SET_LOG(
    AS_USERID    VARCHAR2,
    AS_WLDM      VARCHAR2,
    AS_FUNC      VARCHAR2,
    AS_LX        VARCHAR2,
    AS_HM        VARCHAR2,
    AS_NR        VARCHAR2,
    AN_ERRORCODE OUT NUMBER,
    AS_ERRORMSG  OUT VARCHAR2
) As 
BEGIN
    AN_ERRORCODE := 0;
    AS_ERRORMSG  := NULL; 
    BEGIN
        INSERT INTO T02
            (GDCZHM, GDRZLX, GDRZRQ, GDRZRY, GDRZNR)
        VALUES
            (AS_HM, AS_LX, SYSDATE, AS_USERID, AS_NR);
    END;
END;

CREATE OR REPLACE PROCEDURE P_AM_WOSORD_ORDER_REVOKE
(
	AS_USERID    VARCHAR2,
	AS_WLDM      VARCHAR2,
	AS_FUNC      VARCHAR2,
	AS_GDCZHM    VARCHAR2,
	AS_MBZBDM    VARCHAR2,
	AN_ERRORCODE OUT NUMBER,
	AS_ERRORMSG  OUT VARCHAR2
) As 
BEGIN
	AN_ERRORCODE := 0;
	AS_ERRORMSG  := NULL; 
	BEGIN
		AN_ERRORCODE := -1;
		AS_ERRORMSG  := '工单打回失败';
		P_AM_WOSORD_SET_LOG(AS_USERID,
				    AS_WLDM,
				    AS_FUNC,
				    '30',
				    AS_GDCZHM,
			            LS_LOG,
			            AN_ERRORCODE,
			            AS_ERRORMSG);
           --sqlserver中引用存储过程
              --EXEC p_am_wosord_set_log @as_userid,@as_wldm,@as_func,
              --      '10',@as_new_gdczhm,@ls_nr,@an_errorcode OUTPUT,@as_errormsg OUTPUT ;
               IF AN_ERRORCODE <> 0 THEN
			BEGIN
				RETURN;
			END;
		END IF;
	
		AN_ERRORCODE := 0;
		AS_ERRORMSG  := NULL;
	EXCEPTION
		WHEN OTHERS THEN
			AN_ERRORCODE := -1;
			IF LENGTH(NVL(AS_ERRORMSG, NULL)) = 0 THEN
				BEGIN
					AS_ERRORMSG := SQLERRM;
				END;
			END IF;
			AS_ERRORMSG := LS_STORENAME || ':' || AS_ERRORMSG;
			RAISE_APPLICATION_ERROR(-20001, AS_ERRORMSG);
	END;
END;