| SQLDescribeCol, SQLColAttribute fail for XML column [message #337280] |
Wed, 30 July 2008 07:40  |
letnicie
Messages: 3
Registered: July 2008
|
Junior Member |
|
|
Hi,
I use Oracle 10 & 11 with ODBC drivers 10.02.00.01 and 11.01.00.06.
After executing "SELECT MYXMLCOL FROM MYTABLE" I call SQLNumResultCols and it tells me I have 1 column, then I call:
szColumn[ 0 ] = 0;
nSQLDataType = 0;
nRetVal = SQLDescribeCol(
hStmt,
i,
szColumn,
ICDB_ODBC_STR_LEN,
&nActualLen,
&nSQLDataType,
...
);
it returns SQL_SUCCESS_WITH_INFO and szColumn is empty, nSQLDataType is equal to zero. OK, then I call SQLGetDiagRec and it tells me:
SQLState 00000
other fields are empty.
What is going on here???
It's OK for any other type except XML!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
