Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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_ID | IMAGE_KEY | IMAGE |
| 1 | TEST 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,
This post has been answered by M.Emmanuel on Apr 24 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2016
Added on Apr 24 2016
#apex-discussions, #image
3 comments
1,050 views