- create or replace procedure p103_change_label_body_str
- (
- p_dequeue_body In Mt_Struc,
- p_res_str Out Varchar2,
- p_label Out varchar2,
- p_body Out varchar2
- )/*
- 功能:把出队列的字符串翻译成有规则的label,和body
- */
- Is
- ---写日志区域
- vPid NUMBER:=103;
- vProName VARCHAR2(50):='p103_change_label_body_str';
- vProTip VARCHAR2(255);
- vErrorCode VARCHAR2(20);
- vErrorMsg VARCHAR2(2000);
- --label
- v_label Varchar2(50);
- v_client_id Number;
- v_date_str varchar2(20);
- --body
- v_PRDID varchar2(10);
- v_CHANNELID varchar2(10);
- v_ActionID varchar2(20);
- v_Result varchar2(20);
- v_MSGID varchar2(20);
- v_Pk_total varchar2(20);
- v_Pk_Number varchar2(20);
- v_RegisteredDelivery varchar2(20);
- v_ServiceID varchar2(20);
- v_FeeUserType varchar2(20);
- v_FeeTerminalID varchar2(35);
- v_MsgFmt varchar2(20);
- v_FeeType varchar2(20);
- v_FeeCode varchar2(20);
- v_SrcID varchar2(30);
- v_DestID varchar2(35);
- v_LinkID varchar2(20);
- v_MTFlag varchar2(20);
- v_FixedCode varchar2(20);
- v_RepeatNum varchar2(20);
- v_InfoID varchar2(20);
- v_MsgContent varchar2(150);
- -------------------------------------
- v_body varchar2(2000);
- begin
- p_res_str:='-1';
- v_Result :='';
- v_MSGID :='';
- v_Pk_total :='';
- v_Pk_Number:='';
- --label
- Select to_char(Sysdate,'YY-MM-DD HH:MM:SS') Into v_date_str From dual ;
- If p_dequeue_body.CLIENT_ID>150 Then
- v_label:='022000000'||v_date_str;
- Else
- v_label:='021000000'||v_date_str;
- End If;
- --body
- v_PRDID:='0000' ; v_CHANNELID:='0000'; v_ActionID:='0';
- v_Result :=lpad(' ',8,' ');
- v_MSGID :=lpad(' ',16,' ');
- v_Pk_total :=lpad(' ',1,' ');
- v_Pk_Number:=lpad(' ',1,' ');
- --v_RegisteredDelivery
- v_RegisteredDelivery:=lpad(p_dequeue_body.BEG_REPORT,1,' ');
- --v_ServiceID
- v_ServiceID:=lpad(p_dequeue_body.SERVICE_ID,10,' ');
- --v_FeeUserType
- v_FeeUserType:='0';
- --v_FeeTerminalID
- v_FeeTerminalID:=lpad(p_dequeue_body.FEE_MOBILENO,32,' ');
- --v_MsgFmt
- v_MsgFmt:=lpad(p_dequeue_body.MSG_FMT,2,' ');
- --v_FeeType
- v_FeeType:=lpad(p_dequeue_body.FEE_TYPE,2,' ');
- --v_FeeCode
- v_FeeCode:=lpad(p_dequeue_body.FEE_VALUE,6,' ');
- --v_SrcID
- v_SrcID:=lpad(p_dequeue_body.LONG_NO,21,' ');
- --v_DestID
- v_DestID:=lpad(p_dequeue_body.DEST_MOBILENO,32,' ');
- --v_LinkID
- v_LinkID:=lpad(' ',20,' ');
- --v_MTFlag varchar2(20);
- v_MTFlag:=lpad(p_dequeue_body.MT_FLAG,2,' ');
- ---v_FixedCode varchar2(20);
- v_FixedCode:=lpad(' ',6,' ');
- --v_RepeatNum varchar2(20);
- v_RepeatNum:='1';
- --v_InfoID varchar2(20);
- v_InfoID:=lpad(' ',16,' ');
- --v_MsgContent varchar2(150);
- v_MsgContent:=p_dequeue_body.MT_CONTENT;
- --add
- v_body:=
- (v_PRDID
- ||v_CHANNELID
- ||v_ActionID
- ||v_Result
- ||v_MSGID
- ||v_Pk_total
- ||v_Pk_Number
- ||v_RegisteredDelivery
- ||v_ServiceID
- ||v_FeeUserType
- ||v_FeeTerminalID
- ||v_MsgFmt
- ||v_FeeType
- ||v_FeeCode
- ||v_SrcID
- ||v_DestID
- ||v_LinkID
- ||v_MTFlag
- ||v_FixedCode
- ||v_RepeatNum
- ||v_InfoID
- ||v_MsgContent) ;
- --to value
- p_label:=v_label;
- p_body:=v_body ;
- --result
- p_res_str:='0';
- Exception
- When Others Then
- p_res_str:=Sqlerrm;
- vProTip:='把出队列的字符串翻译异常!';
- vErrorCode:=SQLCODE;
- vErrorMsg:=SQLERRM;
- p_pub_write_error_log(vPid,vProName,'','',
- vProTip,vErrorCode,vErrorMsg,1);
- Rollback;
- end p103_change_label_body_str;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20945761/viewspace-586835/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20945761/viewspace-586835/