Can I call database stored procedure?

Hi,

I would like to execute stored procedure in my database. Is it possible to do it in the SQL query action (e.g. write EXEC MYDB.TestSP) ?

Hi @Evgeny_Lupanov,
Yes, this can be done.

You can use any valid SQL code in the SQL query action. Important is that this code corresponds to your SQL dialect
Here’s an example for SQL Server:

-- Without parameters
EXECUTE DBName.procedureName N’Fizz’, N’Buzz’;
-- With parameters
EXECUTE DBName.procedureName N’Fizz’, N’Buzz’;
-- or
EXECUTE DBName.procedureName @FirstParameter = N’Fizz’, @SecondParameter = N’Buzz’;

MySQL examples:

## Without parameters
CALL DBName.procedureName();
## With parameters
CALL DBName.procedureName(‘Fizz’, ‘Buzz’);

Hope this helps!

1 Like