Problems Retrieving The Content Of Columns Of Type TEXT from PostgreSQL - No Data Returned and Sqlstate 01004 in Trace File.
(Doc ID 1425906.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
DG4ODBC is used to connect to PostgreSQL. A query like the following returns nothing, though there is data in the table column -
SQL> SELECT "text_col" FROM "postgresql_table"@dblink_to_postgresql
The column "text_col" is of type TEXT. The problem does not happen on VARCHAR columns.
The gateways trace file shows an output like the following:
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
12 VARCHAR Y 0 0 0/ 0 0 0 200 text_col
Entered hgopoer at 2012/02/14-14:40:46
hgopoer, line 233: got native error -2 and sqlstate 01004; message follows...
Fetched item was truncated. {01004,NativeErr = -2}
Exiting hgopoer, rc=0 at 2012/02/14-14:40:46
hgoftch, line 740: calling SQLFetch got sqlstate 01004
...
SQLBindCol: column 1, cdatatype: 1, bflsz: 1
12 VARCHAR Y 0 0 0/ 0 0 0 200 text_col
Entered hgopoer at 2012/02/14-14:40:46
hgopoer, line 233: got native error -2 and sqlstate 01004; message follows...
Fetched item was truncated. {01004,NativeErr = -2}
Exiting hgopoer, rc=0 at 2012/02/14-14:40:46
hgoftch, line 740: calling SQLFetch got sqlstate 01004
...
SQLBindCol: column 1, cdatatype: 1, bflsz: 1
And the ODBC trace file shows something like this:
[ODBC][23164][SQLBindCol.c][165]
Entry:
Statement = 0xc04efa0
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xc078a08
Buffer Length = 1
StrLen Or Ind = 0xc07df90
Entry:
Statement = 0xc04efa0
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xc078a08
Buffer Length = 1
StrLen Or Ind = 0xc07df90
Cause
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
| Symptoms |
| Cause |
| Solution |