Oracle 11.1.0 and odbc

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

Oracle 11.1.0 and odbc

Post by NewsgroupServer » 16 Dec 2008, 17:17

 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

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

Oracle 11.1.0 and odbc

Post by NewsgroupServer » 17 Dec 2008, 20:48

 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

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests