I have declared the following user defined table type
x
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