Skip to Main Content

Uploading images in APEX

M EmmanuelApr 24 2016 — edited Apr 24 2016

Hi,

I have the table named CAT_IMAGE to store images:

pastedImage_0.png

I have created a form on CAT_IMAGE,

it creates a FILE UPLOAD item for IMAGE.

pastedImage_11.png

When I upload the image and then go to SQL Command and type

SELECT CAT_IMAGE_ID, IMAGE_KEY, IMAGE FROM CAT_IMAGE

I get "Unsuported Data Type" in the uploaded row for the IMAGE column.

CAT_IMAGE_IDIMAGE_KEYIMAGE
1TEST IMAGE 1[unsupported data type]



Was the image correctly upload?

I want to display later the image in a classic report, but first I want to ensure that I am uploading it properly.
I am using APEX 5.0.3.00.03, Oracle XE 11g Release 2 and Universal Theme.

Thanks,

Comments
Post Details
Added on Apr 24 2016
3 comments
888 views