Home » RDBMS Server » Enterprise Manager » Bind Variables are defined as VARCHAR2 for table columns of CHAR data type in OCI
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

Previous Topic: DBSNMP account
Next Topic: Installaing OEM
Goto Forum:
  


Current Time: Sun Dec 11 08:31:23 CST 2016

Total time taken to generate the page: 0.13495 seconds