UDTs to Stored Procedure

[sameerteni]

Hello,

I have defined a user defined type in C# and DLL is registered with SQL server. I could access defined UDT that in Stored procedure or in SQL query. But when I define stored procedure and tries to execute it, the following error occures -

".NET Framework execution was aborted because of stack overflow."

I have written the following code.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[TempSP]
@I_Collections CollectionsBE = null,
@I_CUSTOMER_ID NUMERIC(19) = NULL OUTPUT
AS
BEGIN
-- PRINT @I_Collections.Description
-- PRINT @I_Collections.Value
select * from CUSTOMERS where CUS_TYPE = @I_Collections.Value
END

Commented print statements are working fine. Only SQL query is not working in Stored Procedure. If I copy paste this code outside the SP and executed in query analyzer then also it works fine. Only SQL queries are not working.

Thanks in Advance,
Sameer