我在sql2000写了一个存储过程，利用游标取一个text类型的字段值，语法没错但在做数据窗口时报错，提示varbinary和text类型不匹配，不能转换，不知为何？存储过程如下：


CREATE PROCEDURE sp_enterprise_advice ( --企业建议


@enterp_code varchar(10),


@question_date datetime)


as


declare @blatitude_code varchar(10),


@blatitude_name varchar(50),


@blatitude_mark decimal(12,3),


@blatitude_advice varbinary(16),


@min_score decimal(12,3),


@max_score decimal(12,3),


@blatitude_value varchar(10)





CREATE TABLE #LATITUDE_CONTENT_TEMP(


ENTERP_CODE VARCHAR(10) not null,


QUESTION_DATE DATETIME not null,


LATITUDE_CODE VARCHAR(10) not null,


LATITUDE_NAME VARCHAR(50) null,


LATITUDE_MARK DECIMAL(12,3) null,


LATITUDE_ADVICE TEXT null,


LATITUDE_VALUE VARCHAR(10) null,


TYPE_NAMES VARCHAR(10) NULL)


begin




select @min_score = min_score ,@max_score =
max_score from t_latgradestandard where enterp_code = @enterp_code





DECLARE latitude_advice_cursor CURSOR FOR


select blatitude_code,blatitude_name,blatitude_mark from
t_big_latitude_statistic where enterp_code = @enterp_code and
question_date = @question_date and blatitude_mark < @min_score
order by blatitude_code


OPEN latitude_advice_cursor


FETCH NEXT FROM latitude_advice_cursor


INTO @blatitude_code,@blatitude_name,@blatitude_mark


WHILE @@fetch_status = 0


BEGIN


select @blatitude_advice = TEXTPTR(advice_content) from
t_advice where enterp_code = @enterp_code and latitude_code =
@blatitude_code


READTEXT t_advice.advice_content
@blatitude_advice 0 0





insert into #LATITUDE_CONTENT_TEMP(


ENTERP_CODE,


QUESTION_DATE,


LATITUDE_CODE,


LATITUDE_NAME,


LATITUDE_MARK,


LATITUDE_ADVICE,


LATITUDE_VALUE,


TYPE_NAMES)


values( @enterp_code,


@question_date,


@blatitude_code,


@blatitude_name,


@blatitude_mark,


@blatitude_advice,


@blatitude_value,


'大纬度')


FETCH NEXT FROM latitude_advice_cursor


INTO @blatitude_code,@blatitude_name,@blatitude_mark


end


close latitude_advice_cursor


deallocate latitude_advice_cursor





select * from #LATITUDE_CONTENT_TEMP


end


GO


表结构如下：


create table t_advice


(

enterp_code
varchar(10)
not null,


latitude_code varchar(10) not null,

latitude_name
varchar(50)
null,


remark
varchar(50)
null ,


advice_content text null ,


constraint PK_t_advice primary key clustered (enterp_code, latitude_code)


)请大虾们帮忙看看，指点一下