| Bind Variables are defined as VARCHAR2 for table columns of CHAR data type in OCI [message #264646] |
Tue, 04 September 2007 02:00 |
vijayalakshmi.pinisetti
Messages: 4
Registered: August 2007
|
Junior Member |
|
|
error:Bind Variables are defined as VARCHAR2 for table columns of CHAR data type in OCI
to reproduce:
Whenever a Siebel Application Object Manager submits a SELECT statement including a Bind Variable for a CHAR column in the WHERE clause, the Oracle Connector declares that Bind Variable as VARCHAR2 data type.
Bind Variables for CHAR columns should be declared as CHAR instead of VARCHAR2, in order to avoid implicit data type conversions at the Oracle layer.
Customer is running Oracle 10.2.0.3, and they seem to be hitting an Oracle Database Product Defect similar to MetaLink Bug 4229830 ("Wrong cardinality estimate comparing CHAR to VARCHAR2 literals / peeked binds").
there are telling to do by setting some database initialization hidden parameters.
can any body please help in this error as i am new to DB side. i am hoping the people will help me a lot
thanks in advance
vijaya
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
