What are the challenges you face when working across database platforms? Take the survey
Options

Inline EXEC cannot find just-created stored procedure

gbrittongbritton Posts: 17 Bronze 1
edited November 3, 2017 1:42PM in SQL Prompt
I create a new proc:
CREATE proc dbo.func
(
	@a bit,
	@nota bit out
)

AS
BEGIN
	SET @nota = @a ^ 1
	RETURN 
END
GO

Then call it:
DECLARE @a BIT, @nota bit
EXEC dbo.func @a, @nota OUT
SELECT @nota

Then, I hover over the function call and select "Inline EXEC" from the context menu. I get the error:
SQL Prompt couldn't find the definition of func

Why might that be??
Tagged:

Best Answer

Sign In or Register to comment.