router.post("/getBal", async function (req, res, next) {
  try {
    await req.db.execute(
      "BEGIN PKG_MRC.VERIFY_TERMINAL(:P_USERNAME, :P_PID, :P_TID, :P_TERM_TYPE); END;",
      {
        P_USERNAME: req.jwt.username,
        P_PID: req.body.pid,
        P_TID: req.body.tid,
        P_TERM_TYPE: req.body.termType,
      }
    );

    var data = await req.db.execute(
      "BEGIN PKG_MRC.GET_BAL(:P_PID, :P_TID, :O_BANK_CARD_BAL, :O_APS_CARD_BAL); END;",
      {
        P_PID: req.body.pid,
        P_TID: req.body.tid,
        O_BANK_CARD_BAL: {
          dir: oracledb.BIND_OUT,
          type: oracledb.STRING,
          maxSize: 128,
        },
        O_APS_CARD_BAL: {
          dir: oracledb.BIND_OUT,
          type: oracledb.STRING,
          maxSize: 128,
        },
      }
    );

    await req.db.commit();

    res.send({
      errorCode: 0,
      bankCardBal: data.outBinds.O_BANK_CARD_BAL,
      apsCardBal: data.outBinds.O_APS_CARD_BAL,
    });
  } catch (e) {
    next(e);
  }
});