cause of must declare parm1... from trying create a procedure?

G. Gunn - fs 146 Reputation points
2021-09-25T07:37:14.697+00:00

When trying create a store proc from vst 2017 server explorer for a database under procedure. upon clicking the update arrow
I got the message

135138-sp-create-trouble.jpg

CREATE PROCEDURE [dbo].[_f_fi_sym_tooLong]  
    @fi_sym varchar(32),  
 @fi_class varchar(4),  
 @sMsg varchar(255) output   
AS  
Begin  
 set @sMsg = 'must be 8 or less characters: Fi_Sym=' + @fi_sym+' fi_class='+@fi_class+', except for option symbol (when fi_class=O), max 20, or 11 max if ends with .TO'  
 RETURN -14  
end  

I know the there is no problem with the code itself but why am I getting error on the default parms from the initial stub.

I also get similar problem with functions.
PS I'm migrating a sql anywhere database 10 to sql server, ultimately to sql server 2016 or 2019

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
{count} votes

Accepted answer
  1. Erland Sommarskog 101K Reputation points MVP
    2021-09-25T18:39:50.047+00:00

    I'm not good at SSDT, as I don't use it myself, but it seems that you press Update, which performs an build and update for the entire project, not only the stored procedure you are looking at.

    Try a Build or Validate option which will tell you where in the project you have this error.

    0 comments No comments

0 additional answers

Sort by: Most helpful