Truncation error retrieving 'long' through ODBC

From: Dskdrv <dskdrv_at_cs.com>
Date: 16 Oct 2001 12:58:49 GMT
Message-ID: <20011016085849.01639.00000215@mb-fx.news.cs.com>

Hi,

A question about getting data from Oracle through ODBC on a PC. When getting the text column from table DBA_VIEWS through ODBC, an truncation error is
returned. In SQl*Plus, 'select text from dba_views;' results in the text being truncated
to 80 chars. It can be seen that 'text' is of type long. Command 'show long' shows 80.
Setting long to something bigger like 500 results in the complete text column appearing.

The question is how to handle this problem from a C program which is retrieving data
through ODBC ? Write a C function to set long in Oracle ? Any other ideas ?

Using Oracle 8.0 and 8i with Oracle ODBC driver.

Thanks for any help. Received on Tue Oct 16 2001 - 07:58:49 CDT