Page 1 of 1

Call stored procedure low-code custom SQL

Posted: Wed Jul 28, 2021 8:09 am
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"
}
}

Re: Call stored procedure low-code custom SQL

Posted: Wed Jul 28, 2021 8:21 pm
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 16201 times