GET_VAR behavior different between SQL Server and Oracle

Document ID : KB000087526
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

When utilizing GET_VAR, the results appear different depending on the DB being referenced. GET_VAR calls against SQL Server will work regardless of case for Key or Column values but will not return results unless an exact case match against Oracle. 



 
Cause:
Cause type:
By design
Root Cause: This is due to Oracle being a case sensitive DB - the results would be the same when searching directly on a DB level.
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: No Fix

Additional Information:
Workaround :
Force case rules on a business level for all variable references.