plsql调试存储过程的时候,不能正确的显示begin到end的代码?

CREATE OR REPLACE PROCEDURE check_in_out
 (BEGINDATE IN VARCHAR2,
  ENDDATE IN VARCHAR2,
  AGENTID IN VARCHAR2,
  start1         IN NUMBER,
  limit1         IN NUMBER,
  AN_O_RET_CODE         OUT NUMBER,
  AC_O_RET_MSG          OUT VARCHAR2,
  COUNTALL              OUT NUMBER,
  CUR_RET               OUT PKG_PUB_UTILS.REFCURSOR
 )

as
  limit2 NUMBER := 0;
  BEGIN
   AN_O_RET_CODE := 0;
   AC_O_RET_MSG  := '操作成功';
   select COUNT (*) INTO COUNTALL from (
    select  a.dates as result_01,a.times as result_02,a.logincode as result_03,a.loginorout as result_04 from tb_sso_loginorout a
   
   where a.logincode like '%'|| AGENTID||'%' and
    dates >= BEGINDATE
     and dates <= ENDDATE order by dates desc
   );
  limit2:=limit1;
  if limit1<0 then
    limit2:=COUNTALL;
  end if;
  --/* 结果集返回 */
  OPEN CUR_RET FOR
  SELECT * FROM (SELECT  ROWNUM AS ROW_NUM,WM.* FROM(
         select  a.dates as result_01,a.times as result_02,a.logincode as result_03,a.loginorout as result_04 from tb_sso_loginorout a
   
   where a.logincode like '%'|| AGENTID||'%' and
    dates >= BEGINDATE
     and dates <= ENDDATE order by dates desc
  )WM ) WHERE ROW_NUM BETWEEN  start1  AND  limit2;
  EXCEPTION
    WHEN OTHERS THEN
        AN_O_RET_CODE := -1;
        AC_O_RET_MSG  := '错误代码:' || SQLCODE || CHR(13) || '错误信息:' || SQLERRM;

END check_in_out;

可是调试的时候,显示的却是
图片描述

阅读 1.4k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题