创建SP 遇到的1个问题

ssybase

declare pSJ int default 1;     -- 升级降级年
   
    select    CAST(CUR_VAL as  int) into pSJ  from BFCRM.BFCONFIG WHERE JLBH = 520000120 ;   --此行导致报错,为什么????


    declare not_found  condition for sqlState '02000';
    declare Cur_SJJ    _HYXX cursor for
        select H.HYID,H.HYK_NO,H.HYKTYPE,H.SJRQ,S.HYKTYPE_NEW,J.WCLJF,J.BQJF,J.BNLJJF,J.LJJF,coalesce(Max(X.JE),0) ZDJE,S.QDJF,S.QDJE,S.BJ_SJ
        from HYK_HYXX H left outer join HYK_XFJL X on H.HYID=X.HYID and date(X.XFSJ)>date(H.SJRQ),HYK_JFZH J,HYK_DJSQGZ S
        where H.HYKTYPE=S.HYKTYPE and H.HYID=J.HYID
        and date(H.SJRQ)<(date(pRCL_DATE)-365 days)
        group by H.HYID,H.HYK_NO,H.HYKTYPE,H.SJRQ,S.HYKTYPE_NEW,J.WCLJF,J.BQJF,J.BNLJJF,J.LJJF,S.QDJF,S.QDJE,S.BJ_SJ
        order by H.HYID
    for read only;
    declare  continue handler for not_found set at_end =1;


创建SP的时候提示:
11:58:33 SQL0007N  跟在 "     declare Cur_SJJ" 之后的字符 "_" 无效。  LINE NUMBER=28.  SQLSTATE=42601

ssybase

declare pSJ int default 1;     -- 升级降级年
   
    select    CAST(CUR_VAL as  int) into pSJ  from BFCRM.BFCONFIG WHERE JLBH = 520000120 ;


    declare not_found  condition for sqlState '02000';
    declare Cur_SJJ    Cur_SJJ_HYXX cursor for
        select H.HYID,H.HYK_NO,H.HYKTYPE,H.SJRQ,S.HYKTYPE_NEW,J.WCLJF,J.BQJF,J.BNLJJF,J.LJJF,coalesce(Max(X.JE),0) ZDJE,S.QDJF,S.QDJE,S.BJ_SJ
        from HYK_HYXX H left outer join HYK_XFJL X on H.HYID=X.HYID and date(X.XFSJ)>date(H.SJRQ),HYK_JFZH J,HYK_DJSQGZ S
        where H.HYKTYPE=S.HYKTYPE and H.HYID=J.HYID
        and date(H.SJRQ)<(date(pRCL_DATE)-365 days)
        group by H.HYID,H.HYK_NO,H.HYKTYPE,H.SJRQ,S.HYKTYPE_NEW,J.WCLJF,J.BQJF,J.BNLJJF,J.LJJF,S.QDJF,S.QDJE,S.BJ_SJ
        order by H.HYID
    for read only;
    declare  continue handler for not_found set at_end =1;

提示:
12:01:33 SQL0104N  在 "" 之后发现意外的标记 "<condition declaration>"。期望的标记可能包括："<SQL statement>"。  LINE NUMBER=27.  SQLSTATE=42601

ssybase

把那行移到别的地方就OK