Home » Applications » Other Application Suites » Bind Variables are defined as VARCHAR2 for table columns of CHAR data type
Bind Variables are defined as VARCHAR2 for table columns of CHAR data type [message #263888] Fri, 31 August 2007 04:10 Go to next message
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

[Updated on: Fri, 31 August 2007 07:08]

Report message to a moderator

Re: Bind Variables are defined as VARCHAR2 for table columns of CHAR data type [message #263973 is a reply to message #263888] Fri, 31 August 2007 07:06 Go to previous messageGo to next message
vijayalakshmi.pinisetti
Messages: 4
Registered: August 2007
Junior Member
No Message Body

[Updated on: Fri, 31 August 2007 07:08]

Report message to a moderator

Re: Bind Variables are defined as VARCHAR2 for table columns of CHAR data type [message #263974 is a reply to message #263973] Fri, 31 August 2007 07:08 Go to previous message
vijayalakshmi.pinisetti
Messages: 4
Registered: August 2007
Junior Member
No Message Body
Previous Topic: OM flow status
Next Topic: Customized forms Upgrading to Multi-org
Goto Forum:
  


Current Time: Thu Mar 28 09:52:29 CDT 2024