GET_VAR behavior different between SQL Server and Oracle
Article ID: 87526
CA Automic Workload Automation - Automation EngineAUTOMIC WORKLOAD AUTOMATION
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 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.