How to Execute SQL Server Stored Procedure in SQL Developer

Question

I have been given access to a SQL Server database with a user account that can only run stored procedures. I added the JTDS SQL Server JDBC jar file as a Third Party JDBC driver in SQL Developer. I can access the SQL Server database with no problems. I was given the following syntax to use while executing the process:

EXEC proc_name 'paramValue1' 'paramValue2'

When I run this as either a statement or a script, I get this error:

Error starting at line 1 in command:
EXEC proc_name 'paramValue1' 'paramValue2'
Error report:
Incorrect syntax near the keyword 'BEGIN'.

I attempted to enclose the statement in BEGIN/END but still received the same issue. Is it possible to use SQL Developer to call the procedure? What syntax must I use if that is the case?

Answer 1

You don't need EXEC clause. Simply use:

proc_name paramValue1, paramValue2

I hope this helps you.