Subject | cast char->varchar |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-05-06T02:38:36Z |
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.
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.