Select BLOB from Oracle issue

General discussion forum about all databases other than SqlBase.
ethanasi
Albania
Posts: 52
Joined: 01 Jun 2020, 14:32
Location: Albania

Select BLOB from Oracle issue

Post by ethanasi » 01 Jul 2013, 15:21

Hi,
I am storing JPEG scanned images in an Oracle database.
I can select and display images bigger that 65KB in size, but when I try to select smaller images, the application just hangs without any response.

Here is the simple select:
SELECT img, ext, length(img)
FROM images
INTO :lsPicture, :sExtention, :nLength
WHERE id=:pnId


In sql.ini:
longbuffer=10000000

Thanks for any hint!

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest