My Oracle Support Banner

ODBC Performs a FULL TABLE SCAN When SQL_WCHAR Is Specified in SQLBindParameter For VARCHAR2 Columns (Doc ID 762091.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle ODBC Driver - Version and later
Information in this document applies to any platform.
***Checked for relevance on 22-Apr-2013***


1)Oracle ODBC does not use the INDEX scan when SQL_WCHAR is specified as parametertype in call to SQLBindParameter for varchar2 column

2) The query is incorrectly performing a full table/index scan instead of an unique/range index scan.

4) When looking at advanced explain plan, sqltxplain or 10053 trace, you notice that the "Predicate Information" shows is doing a "filter(SYS_OP_C2C)".




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.