Question
Wells Fargo
IN
Last activity: 4 Oct 2018 13:54 EDT
Obj-Browse with "Is Equal" on Oracle CHAR type Column is NOT working
Hello,
We have recently migrated our Application Database to Oracle 11g from DB2.
Now, we are facing an issue with Obj-Browse with "Is Equal" on CHAR type columns, as the values in CHAR type column are trailing with spaces to maintain same length
Hello,
We have recently migrated our Application Database to Oracle 11g from DB2.
Now, we are facing an issue with Obj-Browse with "Is Equal" on CHAR type columns, as the values in CHAR type column are trailing with spaces to maintain same length
We have a Database Table with 2 columns Country and State, as shown below. Now we need to get States corresponding to selected country from DB and display in a DropDown.
Country State
CHAR(5) CHAR(10)
------------- --------------
US FLORIDA
US ATLANTA
US WASHINGTON
The same was working fine with DB2 CHAR type columns.
If we change the CHAR to VARCHAR, it works but need to do the same thing for all the CHAR type columns and not sure whether DB team is ready for that do it in PROD.
Please advice...
Regards,
Rajesh
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems
IN
Please share the version of the Pega platform being used along with query generated for this obj-browse with prepared values (You can run tracer and choose DB Query to see the query and the values)
Pegasystems Inc.
IN