Skip to content
Advertisement

Invalid Datatype for user defined table type

I have declared the following user defined table type

CREATE TYPE [component].[programmeList] AS TABLE
(
    ProgrammeId [bigint] NOT NULL
)
GO

Now when i pass it as parameter to an SP

SET QUOTED_IDENTIFIER ON;
SET ANSI_NULLS ON;
GO
CREATE PROCEDURE [component].[Get_Live_Examination_Status]
    @AssessmentPeriodId INT,
    @ResponseFormatType INT,
    @ProgrammeList AS component.programmeList 
AS
BEGIN

I keep getting the following error

Parameter or variable has invalid datatype

Advertisement

Answer

You must pass this argument as :

@ProgrammeList component.programmeList READONLY
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement