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

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());
            call.setLong(InsertOrderPicksTiConstant.P_LINE_NUMBER, saleOutBound.getCarryLineNumber());
            call.setLong(InsertOrderPicksTiConstant.P_ORGANIZATION_ID, saleOutBound.getOrganizationId());
            call.setString(InsertOrderPicksTiConstant.P_ITEM_NUMBER, saleOutBound.getItemNo());
            call.setString(InsertOrderPicksTiConstant.P_FROM_SUBINVENTORY, saleOutBound.getFromWarehouseNo());
            call.setString(InsertOrderPicksTiConstant.P_FROM_LOCATOR, saleOutBound.getFromRackNo());
            call.setString(InsertOrderPicksTiConstant.P_LOT_NUMBER, saleOutBound.getBatchNo());
            call.setString(InsertOrderPicksTiConstant.P_TO_SUBINVENTORY, saleOutBound.getToWarehouseNo());
            call.setString(InsertOrderPicksTiConstant.P_TO_LOCATOR, saleOutBound.getToRackNo());
            call.setDate(InsertOrderPicksTiConstant.P_PICKUP_DATE, new Date(System.currentTimeMillis()));
            call.setLong(InsertOrderPicksTiConstant.P_PICKED_QUANTITY, saleOutBound.getQuantity());
            call.setString(InsertOrderPicksTiConstant.P_PICK_TYPE, "");
            call.setString(InsertOrderPicksTiConstant.P_CREATED_BY_NAME, saleOutBound.getCreateBy());
            call.setString(InsertOrderPicksTiConstant.P_SOURCE_CODE, saleOutBound.getSourceCode());
            call.setLong(InsertOrderPicksTiConstant.P_SOURCE_ID, saleOutBound.getSourceId());
            call.registerOutParameter(InsertOrderPicksTiConstant.x_Return_Status, Types.VARCHAR);
            call.registerOutParameter(InsertOrderPicksTiConstant.x_Return_Msg, Types.VARCHAR);
            call.execute();
        } catch (Exception e) {log.error("调用存储过程发生异常,{}", e);}
        return call;
    }

DateUtil 是引入hutool的时间工具类

call.setString(InsertOrderPicksTiConstant.P_PICKUP_DATE, DateUtil.now());

改为

call.setDate(InsertOrderPicksTiConstant.P_PICKUP_DATE, new Date(System.currentTimeMillis()));