Inline EXEC cannot find just-created stored procedure

gbritton

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??

Michael Clark

Hi @gbritton,

Thanks for reporting that issue.

As you just created the stored procedure, you will need to refresh your suggestions via the menu:
SQL Prompt -> Refresh suggestions

If you would like it to auto-refresh, would it be possible to vote on this UserVoice suggestion:
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/2106127-automatic-suggestion-refresh

Best,
Michael