android 备份 sp,SP的备份.doc

SP的备份

SP的备份

create or replace procedure SP_SEARCH_AH_IN_CTNINFO_ADD(

vLINECODE in varchar2, --箱经营人

vbdate in varchar2, --起始时间

vedate in varchar2, --结束时间

vOPERATIONCODE in varchar2, --操作代码

vpurposecode in varchar2, --进出场目的

vstates in varchar2, --箱状态(空重)

vtqzno in varchar2, --起退租号

vctnsizetype in varchar2, --箱型

vErr_ID out varchar2, --错误号

vErr_DESC out varchar2, --错误的中文描述

vErr_DESE out varchar2, --错误的英文描述

vRC_Result out Clob --返回结果

) is

Type cur_Type is ref Cursor; --定义游标

cCur cur_Type;

vTemp varchar2(10000);

vTempClob1 clob;

vTempClob2 clob;

vTempClob3 clob;

vTempClob4 clob;

vTempClob5 clob;

iCounter1 integer;

iCounter2 integer;

iCounter3 integer;

iCounter4 integer;

iCounter5 integer;

vStrSql varchar2(2500);

--------移箱操作信息

strSERIALNO VARCHAR2(10);

strCONTAINERNO VARCHAR2(11);

strLINECODE VARCHAR2(5);

strCTNSIZETYPE VARCHAR2(4);

strCTNSTATES VARCHAR2(1);

strCTNNETWT VARCHAR2(7);

strCTNGROSSWT VARCHAR2(7);

strFLAG_DAMAGE VARCHAR2(1);

strCFSID VARCHAR2(3);

strYARDID VARCHAR2(3);

strYARDROW VARCHAR2(2);

strYARDLANE VARCHAR2(2);

strYARDELEVATION VARCHAR2(1);

strFLAG_TY VARCHAR2(1);

strREMARK VARCHAR2(200);

strFLAG_SX VARCHAR2(1);

strFLAG_CK VARCHAR2(1);

strMADEDATE VARCHAR2(6);

strIN_DISCH_PORT_ID VARCHAR2(5);

strIN_TRANS_PORT_ID VARCHAR2(5);

strIN_DELI_PORT_ID VARCHAR2(5);

strIN_BLNO VARCHAR2(20);

strIN_TRUCK_LICENSE VARCHAR2(100);

strIN_CTNSEALNO VARCHAR2(20);

strIN_VESSEL_ENNAME VARCHAR2(300);

strIN_VOYAGE VARCHAR2(60);

strIN_OPERATIONCODE VARCHAR2(50