Error HY090 when selecting from SYBASE database
I have a database with Oracle 19 and RHEL 8.
I want to make database link on SYBASE database.
I made the ODBC using unixodbc and works fine.
I made the database link and it works except when selecting certain columns where I'm getting HY090.
For instance.
1) Below works fine
select col1, col2 from schema.table1@dblink
2) Below gives error [SAP][ODBC Driver]Invalid string or buffer length {HY090}
select col3 from schema.table1@dblink
3) Below works fine when using odbc and connecting with isql
select col3 from schema.table1
Must be something with text compatibility. I have set HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1