There is a text field defined in the database. I am working with a stored procedures and trying to insert information into this text field. I am receiving this error: "The text, ntext, and image data types are invalid for local variables."
-- code --
declare @Bas_Txt as text declare @Bas_Cmt_Tx as varchar(200) set @Bas_Txt = '<HTML> </HTML>' set @Bas_Cmt_Tx = 'trial setup'
BEGIN Set NoCount On Insert into dbo.BASELINE(Bas_Txt, Bas_Cmt_Tx) Values (@Bas_Txt, @Bas_Cmt_Tx) END
I have done some looking on google and I am not sure if this can be done. If not, is there a work around?
Stored procedure languages are (usually) specific to their databases, and have nothing to do with Java; you'll probably have better luck on a forum dedicated to whatever database you are using (I can't tell, I don't recognize that particular stored procedure language).
Joseph, It is ok to ask stored procedure questions here at JavaRanch. I recommend editing your post to put the language/database you are using in the subject. That way people who know that language/database are sure to read your post.