declare
gorderno NUMBER(18,0);
gpayamt NUMBER(10,2);
gtimestamp NUMBER(18,0);
gpaycurrency VARCHAR2(10 BYTE);
gbankserial VARCHAR2(64 BYTE);
greturnid VARCHAR2(100 BYTE);
gtravelsky VARCHAR2(50 BYTE);
begin
gorderno:=7345234223412341;
select pay_amt into gpayamt from order_info where order_no=gorderno;
select time_stamp into gtimestamp from order_info where order_no=gorderno;
gpaycurrency:='CNY';
select to_char(sysdate,'yyyymmddhh24miss')||'0010' into gbankserial from dual;
greturnid:='LAPUTA_TEST';--改升支付为CHANGE_KTT
insert into pay_info (。。。。。。)values(。。。, sysdate, gpayamt, '20052', gtimestamp, gpaycurrency,gbankserial, gorderno, greturnid);
commit;
end;
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)