huawei-异常码，异常信息，greast，SQL%NOTFOUND ，%TYPE

CREATE OR REPLACE FUNCTION p_DayLog_CallByService(
  v_CallID VARCHAR2, -- 呼叫标识:标识一个呼叫
  v_SkillID tcurrentbilllog.SkillID%TYPE --呼叫所属的技能队列
) RETURN INTEGER -- 正确返回0,错误返回4
AS
  tSkillID NUMBER(10) := -1; -- 呼叫所属的技能队列
BEGIN
  UPDATE t_DayLogTmp_CallByService
  SET CallNum = CallNum + tCallNum,
  MaxWaitTime = GREATEST(tQueueWaitTime, MaxWaitTime)
  WHERE LogDate = v_LogDate
  AND SkillID = v_SkillID;
  IF SQL%NOTFOUND THEN
  INSERT INTO t_DayLogTmp_CallByService(LogDate,MaxWaitTime)
  VALUES(v_LogDate,tQueueWaitTime);
  END IF;
  RETURN 0;
EXCEPTION
  WHEN OTHERS THEN
  ROLLBACK;
  v_ErrCode := SQLCODE;

v_ErrMsg := SUBSTR(SQLERRM, 1, 200);

INSERT INTO t_DayLog_ErrLog(ErrorCode,ErrorMsg)VALUES

(v_ErrCode,v_ErrMsg);
  COMMIT;
  RETURN 4;
END p_DayLog_CallByService;
/