Subject cast char->varchar
Author guido.klapperich@t-online.de
I have in a SP the following statement
for select cast(DETAIL_TABLE as VarChar(31)), cast(DETAIL_FK_COLUMN as
VarChar(31))
from V_MASTER_DETAIL_RELATIONS where
MASTER_TABLE=upper(:MASTER_TABLE)
into :DETAIL_TABLE, :DETAIL_FK_COLUMN do
BEGIN

DETAIL_TABLE and DETAIL_FK_COLUMN are char(31) and the variables are
varchar(31).
When I execute the sp, I get an conversion error.



Guido.