注册

DPI执行长的sql语句,返回码-70005,返回信息stringTruncated

2022/02/26 3627 4 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:redhat7
【CPU】:
【问题描述】*:DPI执行了一个比较长的sql语句,绑定了33个参数,dpi_exec(sqlstatement)之后,返回码-70005,返回信息string Truncated。数据库后台日志显示收到了这个语句,但是没有执行。是不是sql命令缓冲区超过了?
数据库后台日志:
2022-02-26 12:25:53.511 (EP[0] sess:0x7f4fa8011438 thrd:19436 user:OPERATION trxid:1306769 stmt:0x7f4fa8034430 appname:tmdb ip:::ffff:10.2.70.73) [ORA]: UPDATE T_Instrument SET InstrumentID = ?, ExchangeID = ?, InstrumentName = ?, ExchangeInstID = ?, ProductID = ?, ProductClass = ?, DeliveryYear = ?, DeliveryMonth = ?, MaxMarketOrderVolume = ?, MinMarketOrderVolume = ?, MaxLimitOrderVolume = ?, MinLimitOrderVolume = ?, VolumeMultiple = ?, PriceTick = ?, CreateDate = ?, OpenDate = ?, ExpireDate = ?, StartDelivDate = ?, EndDelivDate = ?, InstLifePhase = ?, IsTrading = ?, PositionType = ?, PositionDateType = ?, LongMarginRatio = ?, ShortMarginRatio = ?, MaxMarginSideAlgorithm = ?, UnderlyingInstrID = ?, StrikePrice = ?, OptionsType = ?, UnderlyingMultiple = ?, CombinationType = ? WHERE InstrumentID=? AND ExchangeID=?^M

另外有没有办法看到,绑定变量以后的,完整的sql语句?

回答 0
暂无回答
扫一扫
联系客服