My Oracle Support Banner

ODBC Throws S1004 When Fetching ROWID Type Column from Resultset by SQLColumns() (Doc ID 2715210.1)

Last updated on OCTOBER 05, 2020

Applies to:

Oracle ODBC Driver - Version and later
Information in this document applies to any platform.


ODBC throws S1004 'String data, right-truncated' when fetching data for 'ROWID' type column from resultset generated by SQLColumns().

The sequence of operations is as follows:

  1. Call SQLColumns() for a table which has a 'ROWID' type column, such as below:
  2. Call SQLBindCol() against each column of resultset for fetching data
  3. Call SQLFetch() repeatedly
  4. SQLFetch() returns S1004 when fetching data corresponding to the column whose data type is 'ROWID' (in the above example, it is 'PND_ROWID')

According to the returned data, it doesn't seem that the data truncation occurred.






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.