DatabaseColumnSize wrong? (PB 5.72 x64 Win)

[wayne-c]

In an environment with an Oracle database, connected via ODBC (64bit), I have the following code to automatically return a blob image as a Base64 string:

Code: Select all

If DatabaseColumnType(hDatabase, k) = #PB_Database_Blob
	BufferLength = DatabaseColumnSize(hDatabase, k)

	; BUFFERLENGTH IS ALWAYS = 2147483647 !!!

	If BufferLength > 0
		*Buffer = AllocateMemory(BufferLength)
		If *Buffer <> 0
			If GetDatabaseBlob(hDatabase, k, *Buffer, BufferLength)
				Field$ = Base64Encoder(*Buffer, BufferLength)
			EndIf
			FreeMemory(*Buffer)
		EndIf
	EndIf
Else
	Field$ = GetDatabaseString(hDatabase, k)
EndIf

DatabaseColumnSize() always returns the value of 2147483647, which is obviously not the actual blob size
Maybe a bug in the DatabaseColumnSize() function?

[the.weavster]

BLOBs are often stored in the table as a pointer and the actual data is elsewhere. 2147483647 is the largest value a 32-bit integer can represent so I should think this is something to do with the field in the table being a pointer.

[wayne-c]

@the.weavster: but there is the function GetDatabaseBlob() and this function should handle all this (pointer or direct data), not?

Ok next question: has anybody succeeded in loading a Blob from Oracle via ODBC ??? How ???

[kpeters58]

Just wondering: Does DatabaseColumnType return #PB_Database_Blob?

[idle]

if It's returning -1, it's likely reporting an error but I can't see anything in the docs that would suggest that, what does DatabaseError() say?