GET_VAR behavior different between SQL Server and Oracle
Article ID: 87526
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
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.
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.
Environment
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Component:
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.
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
Fix Status: No Fix
Additional Information
Workaround :
Force case rules on a business level for all variable references.
Force case rules on a business level for all variable references.
Feedback
Yes
No
Powered by
