Cannot find data type

[rajeshkanna]

Hi all,

I user defined the data type "t_varchar_15"

The following is the sample sp.

create procedure test
as
begin
DECLARE @tmp_TBL TABLE(empno t_varchar_15)
insert into @tmp_tbl select empno from employee
select * from @tmp_tbl
end
go

The Error is
Column or parameter #1: Cannot find data type t_varchar_15.

How to solve this problem. Anyone help me.

N. Rajesh kanna
India

 

[dickiebird]

First, check that it really has been created with sp_help

Dickie Bird (-)))

 

[maswien]

You can change it to following and it does the same thing.

create procedure test
as
begin
create table #tmp_tbl(empno t_varchar_15)
insert into #tmp_tbl select empno from employee
select * from #tmp_tbl
end
go