Solved TD-23777: Oracle DBP_LONGBUFFER not working in 6.3.9

Post found bugs and possible workarounds.
-tommi
Finland
Posts: 8
Joined: 03 May 2017, 08:00
Location: Finland

TD-23777: Oracle DBP_LONGBUFFER not working in 6.3.9

Post by -tommi » 21 Dec 2017, 15:32

Hi.

We fetch BLOB-data from Oracle with DBP_LONGBUFFER etc. parameters.
It was working in 6.3. Update 1R, but after upgrading to 6.3.9 it is not working anymore.
All data is truncated at around 64k.

We have the usual settings for binary fetch:

Code: Select all

--At the beginning:
Call SqlSetParameterAll ( hSql, DBP_ORAUSELOB, TRUE, '', TRUE )
Call SqlSetParameterAll ( hSql, DBP_LONGBUFFER, 32*1024*1024, '', TRUE )
---and before execute:
Call SqlSetLongBindDatatype( 1, 23 )
I have tried with different Oracle Clients, but the TD-version seems to be the problem here.
Any ideas?

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 471
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: Oracle DBP_LONGBUFFER not working in 6.3.9

Post by Dave Rabelink » 21 Dec 2017, 17:16

Already reported.
Read this :

viewtopic.php?f=26&t=45763
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Bug Reports”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests