How to Execute SQL Server Stored Procedure in SQL Developer

Question

I ve been given a user account to a SQL Server database that only has privileges to execute a stored procedure  I added the JTDS SQL Server JDBC jar file to SQL Developer and added it as a Third Party JDBC driver  I can successfully log in to the SQL Server database   I was given this syntax for running the procedure   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 tried wrapping the statement in BEGIN END  but get the same error   Is it possible to call the procedure from SQL Developer   If so  what syntax do I need to use

User · Answer

EXEC proc name  paramValue1   0   paramValue2    some text   GO   If the Stored Procedure objective is to perform an INSERT on a table that has an Identity field declared  then the field  in this scenario  paramValue1  should be declared and just pass the value 0  because it will be auto-increment

User · Answer

The stored procedures can be run in sql developer tool using the below syntax  BEGIN procedurename    END   If there are any parameters then it has to be passed

User · Answer

You need to add a     between the paramValue1 and paramValue2  You missed it  EXEC proc name  paramValue1   paramValue2

User · Answer

Select   from Table name   i e are you save table name in sql TEST  k   Select   from TEST then you will execute your project

User · Answer

EXECUTE  or EXEC  procedure name    parameter 1 Name    parameter 1 Value         parameter 2 name    parameter 2 value        parameter z name    parameter z value

User · Answer

I know this is the old one  But this may help others   I have added SP calling function between BEGIN END  Here is a working script   ALTER Proc  dbo   DepartmentAddOrEdit   Id int   Code varchar 100    Name varchar 100    IsActive bit    LocationId int   CreatedBy int   UpdatedBy int AS     IF  Id   0       BEGIN     INSERT INTO Department  Code Name IsActive LocationId CreatedBy UpdatedBy CreatedAt          VALUES  Code  Name  IsActive  LocationId  CreatedBy  UpdatedBy CURRENT TIMESTAMP       EXEC dbo LogAdd  CreatedBy  DEPARTMENT   Name     END      ELSE      UPDATE Department SET         Code    Code          Name    Name          IsActive    IsActive          LocationId    LocationId          CreatedBy    CreatedBy          UpdatedBy    UpdatedBy          UpdatedAt    CURRENT TIMESTAMP      where Id    Id

User · Answer

You need to do this       exec procName       parameter 1 Name    parameter 1 Value         parameter 2 name    parameter 2 value        parameter z name    parameter z value

User · Answer

You don t need EXEC clause  Simply use  proc name paramValue1  paramValue2    and you need commas as Misnomer mentioned

User · Answer

If you simply need to excute your stored procedure  proc name  paramValue1     paramValue2     at the same time you are executing more than one query like one select query and stored procedure you have to add  select   from tableName EXEC proc name paramValue1   paramValue2

User · Answer

You are  missing    EXEC proc name  paramValue1   paramValue2

[sql-server] How to Execute SQL Server Stored Procedure in SQL Developer?

Examples related to sql-server

Examples related to stored-procedures

Examples related to oracle-sqldeveloper