You’re offline. This is a read only version of the page.
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
#1
WarrenBelz
254
Most Valuable Professional
#2
MS.Ragavendar
134
#3
stampcoin
117
Share
Report
All responses (
Answers (