Unanswered

Error getting while performing execute sql statement using power automate desktop

(0) Share

Report

Posted on by Rahul_skl

Hello All,

Hope you are doing good. I hope someone can help me out in tresolving the error i am getting. I am facing an issue while executing a stored procedure using execute sql query action from power automate desktop . Its throwing me syntax error. I have tried query as :- Exec sp_insert2 %CurrentItem[0]%, %CurrentItem[1]%, %CurrentItem[2]% as well as Exec sp_insert2 '%CurrentItem[0]%', '%CurrentItem[1]%', '%CurrentItem[2]%' but i am still getting the syntax error.

Please note i am trying to read the data from excel file and storing it in oracle database. Please find the attached workflow, as well as the stored procedure which i wrote . workflow execsql.PNG

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Rahul_skl

Try the below syntax:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Rahul_skl 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Deenuji for replying. But the syntax you wrote does not work with oracle database and stored procedure . In general i think the syntax which i was trying before works fine with mysql database . I figured it out by myself. Thank You for your help 🙂

Was this reply helpful? Yes No