Select BLOB from Oracle issue

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

Select BLOB from Oracle issue

Post by ethanasi » 01 Jul 2013, 15:21

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:

Thanks for any hint!

Return to “General Discussion”

Who is online

Users browsing this forum: [Applebot], [Ccbot] and 0 guests