Call stored procedure low-code custom SQL

Use this board to ask questions or have discussions with other Profound.js users.
dpagnotta
New User
Posts: 2
Joined: Tue Jul 27, 2021 1:20 pm
First Name: Dominick
Last Name: Pagnotta
Company Name: Tidestick Consulting, llc
State / Province: North Carolina
Country: United States
Contact:

Call stored procedure low-code custom SQL

Post by dpagnotta »

I'm getting the following error when trying to call a stored procedure with low-code Custom SQL
CALL getCountries(?)

{
"error": {
"message": "C:\\profoundjs\\modules\\tutorial\\storedprocedure.api.json:69 _data = pjs.query(pjs.getDB(\"MariaDB\"), `CALL getCountries(?) SyntaxError: missing ) after argument list"
}
}
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Call stored procedure low-code custom SQL

Post by Scott Klement »

Hello!

Can you tell us what options you used, and what this stored procedure is expecting you to pass, etc? Or, is this from an example that is online somewhere, if so, can you tell us where you found it?

I tried the following, but I did not have any problems with it:
customSQL.png
customSQL.png (15.75 KiB) Viewed 15546 times
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests