Hi
We are trying to fetch records from Postgre Tables.
We are successfully able to build connectivity. We are Using Postgre ODBC Driver (Unicode).
But when I query the tables of Postgre it is unable to map the datatype varchar of source Table.
We got following Reply from Oracle Support.
---------------------------------------------------------------------------------------------------------
Hi,
.
DATA COLLECTED
===============
TRACE FILE
------------
mylog_3388.log
.
ISSUE VERIFICATION
===================
Verified the issue by the trace file mylog_3388.log, which displays
[4464]**** PGAPI_DescribeCol: res = 22422104, stmt->status = 2, !finished=1, !premature=0
[4464]getCharColumnSize: type=1043, col=2, unknown = 0
[4464]describeCol: col 2 fieldname = 'name'
[4464]describeCol: col 2 fieldtype = 1043
[4464]describeCol: col 2 column_size = 50
[4464]getCharColumnSize: type=1043, col=2, unknown = 0
[4464]describeCol: col 2 *pfSqlType = -9
[4464]describeCol: col 2 *pcbColDef = 50
[4464]describeCol: col 2 *pibScale = 0
[4464]describeCol: col 2 *pfNullable = 1
.
CAUSE DETERMINATION
====================
VARCHAR datatype from PostgreSQL is translated by your ODBC driver in an unsupported datatype for HSODBC.
CAUSE JUSTIFICATION
====================
In the trace file, you get the datatype from postgreSQL
====>1043 VARCHAR(50)
then you get the datatype that ODBC driver is mapping to get back to Oracle
====>[4464]describeCol: col 2 *pfSqlType = -9
If you look at in the Note 252548.1,
-9 is SQL_WVARCHAR
and unfortunately this ODBC datatype is not supported by the Generic Connectivity agent (HSODBC).
To get confirmation, please have a look in the documentation:
Oracle® Database Heterogeneous Connectivity Administrator's Guide
10g Release 2 (10.2)
Part Number B14232-01
B Data Type Mapping for Generic Connectivity
B.1 Mapping ANSI Data Types to Oracle Data Types Through an ODBC Interface
.
POTENTIAL SOLUTION(S)
======================
Please check if in your ODBC driver there is any option to differently map the SQL_WVARCHAR d
atatype
-----------------------------------------------------------------------------------------------------------
Can you please suggest why varchar datatype is not correctly identified and what is the path to get solution?
Thanks & Regards
Vidisha B Shah
Vidisha B Shah
Tata Consultancy Services Limited
Mailto: [EMAIL PROTECTED]
Website: http://www.tcs.com
Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
