
ALTER TABLE SHIPMENT ADD PRO_NO varchar2(40);

ALTER TABLE SHIPMENT MODIFY REMARKS VARCHAR2(200);
 

Insert into messages (MSG_NO,MSG_STR,MSG_DESCR,MSG_TYPE,MSG_OPT,MSG_TIME,ALARM,ERR_SOURCE,CHG_DATE,CHG_USER,CHG_TERM,OVERRIDE_INPUT,MAIL_OPTION) 
values ('VTPRONONUL','PRO NO Null','Please select another transporter.','E','Y',null,null,null,null,null,null,null,null);


Insert into messages (MSG_NO,MSG_STR,MSG_DESCR,MSG_TYPE,MSG_OPT,MSG_TIME,ALARM,ERR_SOURCE,CHG_DATE,CHG_USER,CHG_TERM,OVERRIDE_INPUT,MAIL_OPTION) 
values ('VMPRONOCD','PRO NO INVALID','Pro No should be in between Pro No from and Pro No To.','E','Y',null,null,null,null,null,null,null,null);

