select S_LOG_NO.Nextval LOG_NO from dual select * from CMMTTXIF where TXN_COD='%s' TXN_CD select * from CMMTRSTS where SYS_DT='%s' and STS='1' SYS_DT SELECT COUNT(*) MENUROW FROM CMMTFUNC WHERE func_no='%s' TXN_CD| SELECT COUNT(*) TXNROW FROM CMMTFUNCROLE r,cmmtoperrole o WHERE r.role_id = o.role_id AND o.oper_no='%s' AND r.FUNC_NO='%s' CUR_OPER_NO|TXN_CD| SESSION_TMOUT=1 GWA.MSG_CD=SCM00001 UPD_OPER=$CUR_OPER_NO CUR_OPR_ID=$CUR_OPER_NO SYS_DT=GETDATE() LOG_NO=STRCAT($SYS_DT,PAD($LOG_NO,1,9,0)) SCOP_SQL=STRCAT(DEPT.PROV_CD=',$CUR_OPER_PROV,') SCOP_SQL=STRCAT(DEPT.CITY_CD=',$CUR_OPER_CITY,') SCOP_SQL=STRCAT(1=,1) AC_DT=$SYS_DT BUS_TYP=$TX_ATTR.BUS_TYP TXN_TYP=$TX_ATTR.TXN_TYP GWA.BUS_CNL=BUI GWA.SYS_CNL=CAP GWA.MSG_CD=SCM00000 IP_ADDR=@MSG.SIP OPER_PWD=BLANK(2) GWA.MSG_CD=SCM60001 GWA.MSG_CD=SCM60002 GWA.MSG_CD=SCM60003 GWA.MSG_TYP=N GWA.MSG_TYP=E GWA.MSG_INF=系统正忙,请稍后提交 AREA1.OPR_PROV=$CUR_OPER_PROV AREA1.OPR_CITY=$CUR_OPER_CITY AREA1.OPR_DEPT=$CUR_OPER_DEPT AREA1.OPR_ID=$CUR_OPER_NO