Search code examples
sql-servert-sqlstored-procedures

Stored procedure creation error in SQL Server 2022

I attached a database to SQL Server 2022 version and added a new table URLabelHeader. While adding a new stored procedure I am getting the following error.

CREATE PROCEDURE [dbo].[spSaveURLprocess]  
    (@tblURLlabelHeader [dbo].tblURLabelHeader READONLY)
AS  
BEGIN  
    SET NOCOUNT ON;.....

Error:

Msg 2715, Level 16, State 3, Procedure spSaveURLprocess, Line 10 [Batch Start Line 6]
Column, parameter, or variable #1: Cannot find data type dbo.tblURLlabelHeader.
Parameter or variable '@tblURLlabelHeader' has an invalid data type.

The parameter @tblURLlabelHeader cannot be declared READONLY since it is not a table-valued parameter.

Can anyone please help me?

I try to add a new stored procedure in SQL Server 2022.

Solution

  • after @tblURLlabelHeader you must define it's type. like @tblURLlabelHeader Varchar(8000).

    There is no such value type tblURLabelHeader in SQL server 2022

    So that is a user defined data type. and you must create that user-defined data type, before creating your new SP.

    You can find definition of that data type in : Programmability>Types>User-Defined Table types. (First create that data Type)