blocks|key|881256|text|您不需要EXEC子句。只需使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881257|proc_name+paramValue1,+paramValue2|code-block|syntax|javascript|881258|(你需要用逗号来代替前面提到的用词不当的地方)|881259|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You don't need EXEC clause. Simply use

<pre><code>proc_name paramValue1, paramValue2
</code></pre>

(and you need commas as Misnomer mentioned)

blocks|key|1095984|text|您缺少,|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1095985|EXEC+proc_name+'paramValue1','paramValue2'|code-block|syntax|javascript|1095986|entityMap^0|3|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You are missing <code>,</code>

<pre><code>EXEC proc_name 'paramValue1','paramValue2'
</code></pre>

blocks|key|1096334|text|您需要这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096335|exec+procName+
@parameter_1_Name+=+'parameter_1_Value',+
@parameter_2_name+=+'parameter_2_value',
@parameter_z_name+=+'parameter_z_value'|code-block|syntax|javascript|1096336|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You need to do this:
<pre><code>exec procName 
@parameter_1_Name = 'parameter_1_Value', 
@parameter_2_name = 'parameter_2_value',
@parameter_z_name = 'parameter_z_value'
</code></pre>

blocks|key|881500|text|EXECUTE+[or+EXEC]+procedure_name
@parameter_1_Name+=+'parameter_1_Value',+
@parameter_2_name+=+'parameter_2_value',
@parameter_z_name+=+'parameter_z_value'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|881501|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>EXECUTE [or EXEC] procedure_name
@parameter_1_Name = 'parameter_1_Value', 
@parameter_2_name = 'parameter_2_value',
@parameter_z_name = 'parameter_z_value'
</code></pre>

blocks|key|881733|text|我知道这是旧的。但这可能会对其他人有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881734|我在BEGIN/END之间添加了SP调用函数。这是一个工作脚本。|881735|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+|code-block|syntax|javascript|881736|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

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.

<pre><code>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 
</code></pre>

blocks|key|1096683|text|您需要在paramValue1和paramValue2之间添加一个'，‘。你错过了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096684|EXEC+proc_name+'paramValue1','paramValue2'|code-block|syntax|javascript|1096685|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You need to add a ',' between the paramValue1 and paramValue2. You missed it.
<pre><code>EXEC proc_name 'paramValue1','paramValue2'
</code></pre>

blocks|key|881644|text|EXEC+proc_name+@paramValue1+=+0,+@paramValue2+=+'some+text';
GO|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|881645|如果存储过程的目标是在声明了标识字段的表上执行INSERT，那么应该声明该字段，并且只传递值0，因为它将是自动递增的。|unstyled|offset|length|style|CODE|881646|entityMap^0|0|N|6|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>EXEC proc_name @paramValue1 = 0, @paramValue2 = 'some text';
GO
</code></pre>

If the Stored Procedure objective is to perform an <code>INSERT</code> on a table that has an Identity field declared, then the field, in this scenario <code>@paramValue1</code>, should be declared and just pass the value 0, because it will be auto-increment.

blocks|key|881576|text|如果只需要在执行多个查询的同时执行存储过程proc_name+'paramValue1'+,+'paramValue2'...，则必须添加select+*+from+tableName+EXEC+proc_name+paramValue1+,+paramValue2...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|881577|entityMap^0|L|16|1X|1V|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

If you simply need to excute your stored procedure 
<code>proc_name 'paramValue1' , 'paramValue2'...</code>
at the same time you are executing more than one query like one select query and stored procedure you have to add <code>
select * from tableName
EXEC proc_name paramValue1 , paramValue2...</code>

blocks|key|881422|text|可以使用以下语法在sql+developer工具中运行存储过程|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881423|BEGIN+procedurename()；END；|881424|如果有任何参数，那么它必须被传递。|881425|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|881482|text|Select+*+from+Table+name+..i.e(are+you+save+table+name+in+sql(TEST)+k.

Select+*+from+TEST+then+you+will+execute+your+project.|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|881483|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Select * from Table name ..i.e(are you save table name in sql(TEST) k.

Select * from TEST then you will execute your project.
</code></pre>

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:

<pre><code>EXEC proc_name 'paramValue1' 'paramValue2'
</code></pre>

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

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

I tried wrapping the statement in <code>BEGIN/END</code>, but get the same error. Is it possible to call the procedure from SQL Developer? If so, what syntax do I need to use?

How to Execute SQL Server Stored Procedure in SQL Developer?

SQL Server

数据库

我被授予了一个SQL Server数据库的用户帐户，该数据库只有执行存储过程的权限。我将JTDS SQL Server JDBC jar文件添加到SQL Developer中，并将其添加为第三方JDBC驱动程序。我可以成功登录到SQL Server数据库。我得到了运行该过程的以下语法：EXEC proc_name 'paramValue1' 'paramValue2'当我将其作为语句或脚本运行时，

问如何在SQL Developer中执行SQL Server存储过程？
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Developer中执行SQL Server存储过程？EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Developer中执行SQL Server存储过程？
EN