摘要:
BEGIN DECLARE t_error INTEGER DEFAULT 0; DECLARE CONTINUE HANDLER FOR 1062 SET t_error=1; set autocommit=0; START TRANSACTION; call put_playerbehavior(i_playerid,i_gameid,i_channelid,i_acttime,@a); IF t_error=1 then rollback; call put_playerbehavior(i_playerid,i_game... 阅读全文
摘要:
CREATE OR REPLACE function UXQLCRM.GET_WEI_XIU(htfid in varchar2) return varchar is htleixingstr varchar2(5000);CURSOR cr_bg_jl is select "FServiceCon", to_char("FInfReceiveTime",'yyyy/mm/dd') FROM "TuProductRepairment" WHERE "FLightOrderId"=htfid ORDE 阅读全文
摘要:
展柜合同头insert into ZVBAK(ZCRMID,ZOPERA,ZSYSTY,ZDATE1,ZTIME1,DOC_TYPE,BUKRS,SALES_ORG,DIVISION,SALES_OFF,SALES_GRP,PSPID,PURCH_NO_C,PURCH_DATE,REQ_DATE_H,PMNTTRMS,BILL_BLOCK,ZFLAG,CFLAG,MANDT,TYPE_GROUP,DISTR_CHAN)values(${entity.FId},1,2,TO_CHAR(now(),'YYYYMMDD'),TO_CHAR(now(),'HHMMSS' 阅读全文
摘要:
insert into ZVBAK(ZCRMID,ZOPERA,ZSYSTY,ZDATE1,ZTIME1,DOC_TYPE,BUKRS,SALES_ORG,DIVISION,SALES_OFF,SALES_GRP,PSPID,PURCH_NO_C,PURCH_DATE,REQ_DATE_H,PMNTTRMS,BILL_BLOCK,ZFLAG,CFLAG,MANDT,TYPE_GROUP,DISTR_CHAN)values(${entity.FId},1,2,TO_CHAR(now(),'YYYYMMDD'),TO_CHAR(now(),'HHMMSS'), 阅读全文