Execute Stored Procedure

Archived Topics
1

Ok how do I execute a stored procedure in FSQL and pass along a variable with it?

I know in FPMI you use the exec ‘proc name’ ‘variables’

Of course without the quotes, but when I try that in FSQL it gives an error.

2

Where are you trying that query? On a expression item?

3

Action Item Configuration
SQL Query radial button checked

4

What is the error you are getting?

5

It will not allow me to save the query.

I have tried

executeQuery(exec proc_name {variable})
exec proc_name {variable}
exec proc_name ‘{variable}’
executeQuery(exec proc_name) notice without variable just to see if it would save it

While it does save some variations most times it says a statement error has occured do you wish to continue.

So what is the correct format for calling a stored procedure from within Factory SQL in the Action Item Configuration section?

6

Well, the query must be in double quotes like:executeQuery(concat("exec proc_name ", {variable}))

7

Travis' response is correct, if you have the "expression" mode selected. With "SQL Query" mode, you should be able to use simply:

exec proc_name {tag}

As Travis asked, what error does it give you when you click OK? The only thing I can get to come up is that the referenced item doesn't exist, if I use a name that doesn't exist in the group.

Regards,