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

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

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

Post by NewsgroupServer » 30 Mar 2009, 18:12

 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

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

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

Post by NewsgroupServer » 31 Mar 2009, 17:09

 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.

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

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

Post by NewsgroupServer » 01 Oct 2009, 17:29

 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

Return to “td.connectivity”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests