记录调用存储过程报异常：在要求输入数字处找到非数字字符

BenzGL550

已于 2023-03-28 14:27:49 修改

阅读量492

点赞数

文章标签：数据库 java sql

于 2023-03-28 14:23:42 首次发布

本文链接：https://blog.youkuaiyun.com/BenzGL550/article/details/129815241

版权

private CallableStatement execute_Insert_Order_Picks_Ti(SaleOutBound saleOutBound) {
        CallableStatement call = null;
        try {
            JdbcUtils.createDriver(yamlProperties.getDriverClassName());
            log.info("{} ,{}  ", yamlProperties.getDriverClassName(), yamlProperties.getUrl());
            Connection connection = YamlProperties.connection;
            String sql = "{call pick.insert_order(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
            call = connection.prepareCall(sql);
            call.setLong(InsertOrderPicksTiConstant.P_SESSION_ID, saleOutBound.getSourceId());
            call.setLong(InsertOrderPicksTiConstant.P_TXN_HEADER_ID, saleOutBound.getCarryNumberHeaderId());
            call.setLong(InsertOrderPicksTiConstant.P_TXN_LINE_ID, saleOutBound.getCarryLineNumberId());
            call.setString(InsertOrderPicksTiConstant.P_REQUEST_NUMBER, saleOutBound.getCarryNumber());