VARCHAR greater than 256 in a PROCEDURE

[essiprojects]

Hi,

I have a PROCEDURE where I have to use a String variable. This String
cannot be a varchar, because it is small. I need something like
LVARCHAR, any type greater than 256 bytes. I have tried to use TEXT, but
I got the error:

608: Illegal attempt to convert Text/Byte blob type.

Does anybody know what I'm doing wrong or what data type can I use?

Thank you.

 

[chessdr]

I think I have a similar problem where I'm trying to insert data into a table with a stored procedure, and one of my columns is defined as TEXT. I too get the error message "Illegal attempt to convert Text/Byte blob type."

Any help would be greatly appreciated!

Thanks,

Craig

 

[essiprojects]

At the end I used char. I think that you cannot use text.