The create or replace procedure yspay_transactionflow is
The begin
New
-INSERT INTO app_trans_info ati
(
Ati. ID, -- -- ID
Ati. TRANSTIME, -- -- sending time order
Ati. TRANSDATE, -- -- sending date order
Ati SENDDATE, sending time - trading
The merchant code ati. MERCHANTCODE, -- --
Ati. TRANSAMT, -- -- transaction
Ati. RESPONSECODE, -- -- channel response code
Ati. SEARCH_TRANS_CODE, -- -- transaction type
Surcharges for ati. APPFEE, -- --
Ati. ORDERID, -- -- the order number associated order table
Ati. CHANNELNO, -- -- channel number
Ati. SYS_ORDERID, -- -- channel flow number
Ati. The RESPONSE, -- --
RESPONSE resultsAti. PAYMENTTYPE - 0 - online payment (balance); 1 - offline payment (credit card)
Ati. APPSN, -- -- the App serial number
Ati. QS_ERROR_CODE, -- -- the liquidation error code
Ati. BATCHNO, -- -- paid batch
Ati. SERIALNO used to -- -- paid water
)
SELECT
(SELECT TRUNC (DBMS_RANDOM VALUE (10000000, 99999999)) FROM dual) AS id, - randomly generated an eight digit id
(SELECT TRUNC (DBMS_RANDOM VALUE (100000, 999999)) FROM dual) AS TRANSTIME, sending time
- to generate orders(select to_char (sysdate, 'yyyyMMdd') from dual) AS TRANSDATE, sending date - to generate orders
(select to_char (sysdate, 'yyyy - MM - dd HH24: mi: ss') from dual) AS SENDDATE, sending time - generated trading
Product data management (PDM). MERC_ID AS MERCHANTCODE, -- -- merchant code
Product data management (PDM). FACTAMOUNT AS TRANSAMT, -- -- transaction
'0001' AS RESPONSECODE, - channel response code
'A019 AS SEARCH_TRANS_CODE - transaction type
Product data management (PDM). ADDFEE AS APPFEE, -- -- surcharge
Product data management (PDM). The ORDERNUM AS ORDERID, -- -- order number
'YS53 AS CHANNELNO, - channel number
(SELECT TRUNC (DBMS_RANDOM VALUE (100000000000, 999999999999)) FROM dual) AS SYS_ORDERID, water - channel number
'A0001' AS the RESPONSE,
- RESPONSE result'0' AS PAYMENTTYPE, - 0 - online payment (balance); 1 - offline payment (credit card)
'A180516400016 AS APPSN, - change
'00' AS QS_ERROR_CODE - liquidation error code
(SELECT TRUNC (DBMS_RANDOM VALUE (10000000, 99999999)) FROM dual) AS BATCHNO, - paid batch
'0012500016' AS SERIALNO used to - paid water
The FROM
PMS_DRAW_MONEY product data management (PDM);
New
-INSERT INTO pms_app_trans_info pati
(
Pati. ID, -- -- ID
Payment pati. PAYMENTTYPE, -- --
Type pati. TRADETYPE, -- --
Pati. TRADETIME, -- -- time
Pati. ORDERID, -- -- transaction number
Pati. PAYAMOUNT, -- -- transaction
Pati. BANKCARDNAME, -- -- the name of the bank card
Pati. MERCNAME, -- -- account name
Pati. BANKNAME, -- -- bank name
Pati. PAYEENAME, -- -- the payee name
Pati. MERCID, -- -- merchant id
Pati. POUNDAGE, -- -- POUNDAGE
Pati. FACTAMOUNT, -- -- the actual amount to merchant account
State of pati. RESPONSESTATE, -- --
Pati. FIELD1, -- --
payment codingPati. FIELD2, -- -- transaction type code
Pati. FILED3, -- -- bank card number
Pati. PORTORDERID, -- -- interface order number
Pati. FINISHTIME, -- -- order completion time
Rate pati. EXTENDS1, -- --
Pati. EXTENDS3,
- requestPati. EXTENDS5, -- -- trading status code
Pati. EXTENDS8
)
SELECT
(SELECT TRUNC (DBMS_RANDOM VALUE (10000000, 99999999)) FROM dual) AS ID, - randomly generated an eight digit ID
'account balance' AS PAYMENTTYPE, payment -
'withdrawals AS TRADETYPE - transaction type
(select to_char (sysdate, 'yyyy - MM - dd HH24: mi: ss') from dual) AS TRADETIME, trading time
Product data management (PDM). The ORDERNUM AS ORDERID, -- -- transaction number
Product data management (PDM). PAYAMOUNT AS PAYAMOUNT, -- -- transaction
Product data management (PDM). BANKNAME AS BANKCARDNAME, -- -- bank card name
Product data management (PDM). SHORTNAME AS MERCNAME, -- -- account name
Product data management (PDM). BANKNAME AS BANKNAME, -- -- bank name
Product data management (PDM). SHORTNAME AS PAYEENAME, -- -- the payee name
Product data management (PDM). MERC_ID AS MERCID, -- -- merchant id
Product data management (PDM). ADDFEE AS POUNDAGE, -- -- POUNDAGE
Product data management (PDM). FACTAMOUNT AS FACTAMOUNT, -- -- the actual amount to merchant account
'deal' AS RESPONSESTATE,
'0' AS FIELD1, - payment code
'5' AS FIELD2, - transaction type code
Product data management (PDM). CLR_MERC AS FILED3, -- -- bank card number
Product data management (PDM). The ORDERNUM AS PORTORDERID, -- -- interface order number
(select to_char (' yyyyMMddHH24miss 'sysdate) from dual) AS FINISHTIME, - order completion time
'0' AS EXTENDS1 - rate
'0' AS EXTENDS3,
- request'3' AS EXTENDS5 - trading status code
'0' AS EXTENDS8
The FROM
PMS_DRAW_MONEY product data management (PDM);
The exception
The WHEN OTHERS THEN
rollback;
END yspay_transactionflow;

CodePudding user response:

Somehow print error,,,

CodePudding user response:

How do the typing errors,,,,

CodePudding user response:

reference code on the second floor wind public response:

how do print error,,,,

Exception handling parts removed first?

CodePudding user response:

Can you commit?

CodePudding user response:

reference 4 floor h932742136 response:

can commit?

This, is there a difference? His problem is that he put the exception handling, but it didn't print,

CodePudding user response:

First, take the output information in exception handling,
Second, to COMMIT,
Third, behind the INSERT can SELECT check out results,