Oracle 9 on a Sun and TD 2.1 PTF4 - a String problem

[Johann]

 Posted by:  Mag. Johann Gregorich 

Hi,
I'm observing here a little strange thing. Selecting a String column
VARCHAR2(200) I get nothing back in my childtable for that particular
column - all other columns have values (Sun OS).

When I try to select this with SQLTalk from the Sun machine, I get a
resutlset even with the missing column, but in a way, which SQLTalk uses
when selecting LONG VARCHAR (which this particular column is not).

When selecting the same table from an oracle on a windows server, everything
is normal.

Has somebody an idea, what this can be?

Regards
Hans

[Jeff Luther]

 Posted by:  Jeff Luther 

"...but in a way, which SQLTalk uses when selecting LONG VARCHAR"

That sounds like a clue to me, Hans, so I would suggest declaring your child
table's column as Long String and trying again. If the router thinks it's a
LONG, then CTD won't use the correct API calls to fetch the data into a
column/field of type String.

- Jeff/Unify Corp.

[Johann]

 Posted by:  Mag. Johann Gregorich 

I found the solution, for your info:

the column definition must be e.g. varchar2(60 byte) then everything is ok.

If the definition is e.g. varchar2(60 char) you get long varchar strings
back and the problem is very perfect :)

Regards
Hans