Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comparing number to varchar

UvaOct 28 2014 — edited Oct 28 2014

Hi All,

I am facing the Big issue,

select count(1)

from qp_pricing_attributes

where product_attr_value=P_item_id

Here P_item_id is Number datatype and product_attr_value is varchar2

the above code works well in SIT and PROD

where it it throwing error in UAT

I also verified the databse verison, all are of same database version.

Please help me what I am missing.

Regards,

Uva

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2014

Added on Oct 28 2014

#database-key-features, #export-import-sql-loader-external-tables

6 comments

1,417 views