Unanswered

Insert Picture into Oracle Database as Blob

Like (0) Share

Report

Posted on 12 Sep 2022 02:39:34 by Community Power Pla...

Dear All,

Please inform me how to input picture into table in Oracle database. I have tried using Patch but its return error ora-01704: string literal too long.

please give me some advice or any other alternative to store a picture from Power Apps into tale in Oracle database. Thanks a lot!

Categories:

Mobile App

All responses (3)

Answers (0)

pjdiii 30 on 24 May 2023 at 17:31:12

Like (0)

Report

Re: Insert Picture into Oracle Database as Blob

Thanks for your reply. We are currently using Oracle Connector to retrieve and write data. Except the blob insert/retrieval is giving us issues. Do you have a working example of your solution?
mmollet 3,187 on 24 May 2023 at 17:03:07

Like (0)

Report

Re: Insert Picture into Oracle Database as Blob

You could use a combination of Power Apps, Power Automate, and that would include having to use the Oracle connector which I believe is a premium connector.

There are steps in that connector that will let you send an image from Power Apps and then insert that into blob storage. Idk if a premium connector is an option but this will be the easiest and fastest way to do this probably.
pjdiii 30 on 24 May 2023 at 16:51:15

Like (0)

Report

Re: Insert Picture into Oracle Database as Blob

Any resolution on this issue, besides breaking into 4k chunks?