Database Utilities (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center