Unanswered

Convert image to blob type (or base64) and save into oracle database

(1) Share

Report

Posted on by HW-10042356-0

Hi, there.

I have a connection to my on-premise oracle database using oracle gateway. The image needs save into oracle database table using "Add Image" control in power app and the patch function. I use the `

Set(base64Image, JSON(AddMediaButton1.Media, JSONFormat.IncludeBinaryData)) to convert the image and saved into the db. However It is not the base64 string but a blob url in the blob type column such as appres://blobmanager/5dd943911028f4f471233222bf0bcdae7cc5eb5c/1 which can not identify as an image when pull out from the database.

Anyone could help how to save an image to a blob or clob column in oracle database ? Thanks, Hai

Categories:

Power Apps Pro Dev & ISV

Screenshot 2025-0...

I have the same question (0)

All responses (2)

Answers (0)

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @HW-10042356-0

Please check this post where this issue is resolved.

Set( base64Image, Substitute(JSON(AddMediaButton1.Image, JSONFormat.IncludeBinaryData),"""", "") )

I don't know what control "Add Image" is but if you use the Image control in Powerapps this would fix the issue.

I hope this helps!

Was this reply helpful? Yes No
HW-10042356-0 4 on at

Like (0)

Report

Hi @SpongYe

Thanks for your help, it did turn the blob url to a base64 string, but it cannot save into oracle database blob or clob column.

Set(base64Image, Substitute(JSON(UploadedImage1.Image, JSONFormat.IncludeBinaryData),"""", ""));

Set(blobImage,JSON(base64Image, JSONFormat.IncludeBinaryData));

Patch('DB_TABLE',Defaults('DB_TABLE'),{IMAGE_BLOB:blobImage});

The blobImage is a string such as "data:image/jpeg;base64,/9j/4A..." and IMAGE_BLOB is the blob type column in oracle db. However, the blobImage cannot save into that column indicating the string is too long.

Any suggestions on how to save the base64 string as a blob type into the db.

Thanks,

Hai

Was this reply helpful? Yes No