Oracle 11.1.0 and odbc

[Klaus Strohmaier]

 Posted by:  Klaus Strohmaier 

Hi,

i connected a oracle 11.1.0 database and sqlbase 8.5.0 sqlbase database (WIN
XP) using the sqlbase odbc driver.
it works fine, until i write a select statement, to display a varchar2 data.

a select statement displays the correct value,
a select distinct or other function statement of a varchar2 field displays a
null value

thanks for all good ideas
Klaus

[StefanM]

 Posted by:  Stefan Misch 

Klaus,

with ORACLE a select with a function that returns a varchar2 returns a
long string. So either you change the bind variable in SAL to be of type
long string or you enclose the function in substr(foo(), 1, 250).

I'm not sure about the select distinct, as I did not encounter this
problem. But I'm using the native router for Oracle and not ODBC.

HTH,
Stefan