Skip to main content

Notifications

Community site session details

Community site session details

Session Id : RxAA+H59vN8bMgrw71c3D1
Power Apps - Building Power Apps
Unanswered

Insert Blob object to Oracle DB

Like (0) ShareShare
ReportReport
Posted on 8 Oct 2019 03:11:26 by 46

Hello.

 

I am trying to insert a user uploaded file (image or pdf) into Oracle DB. On PowerApps, I am capturing the object using the AddPicture object.

 

I have tried both methods; (1) Patch and (2) Flow with insert row action. Both methods return an ORA-01704 error.

 

I am successful in uploading the file onto Sharepoint document library. However, I need the file to be saved in a BLOB column defined in Oracle.

 

Appreciate any help provided. Thanks.

  • prankypp Profile Picture
    2 on 26 Sep 2023 at 17:29:34
    Re: Insert Blob object to Oracle DB

    SQL wont work but writing a PL/SQL block of code will work. 

    Inside your Execute Query , write the below -

    DECLARE
      str BLOB;
    BEGIN
      str := utl_raw.cast_to_raw('<your BLOB data>');

      update XX_TABLE set JPAYLOAD = str where order_reference = 'ABC';
    END;

  • Community Power Platform Member Profile Picture
    on 29 Nov 2021 at 10:46:47
    Re: Insert Blob object to Oracle DB

    Any news concerning this topic?

  • v-monli-msft Profile Picture
    on 09 Oct 2019 at 08:10:42
    Re: Insert Blob object to Oracle DB

    Hi @yoggieb ,

     

    I think this is not avaiable so far in PowerApps. Consider to add an idea in below forum if you need this feature.

     

    https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

     

    Regards,

    Mona

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started