Re: LOB & SQLDescribeParam (ODBC)

From: Shige Takeda <smtakeda_at_earthlink.net>
Date: Thu, 16 Dec 1999 13:27:46 GMT
Message-ID: <3858E98E.27D903EF@earthlink.net>

Check SQORA.WRI at $ORACLE_HOME/ODBC.

> Why does a SQLDescribeParam of a (B)LOB tells me that the type is a
> SQL_VARCHAR with a size of 999 bytes (while it's actually is a
> SQL_LONGVARBINARY with a size of 2Mb)?
> If this is a "feature" it only works fine for very small LOBs ...

No way to know the column information before binding for any data type.

If you need the column information, use "SQLDescribeCol" for SELECT statement first, then update data using the info.

--
Shige Takeda
smtakeda_at_earthlink.net Received on Thu Dec 16 1999 - 07:27:46 CST