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.
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;
Any news concerning this topic?
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
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional