Does CA Service Desk Manager (CA SDM) leverage Oracle Database's Bind Variables?

Article Id: 17422
Status: Published
Updated On: 14-02-2018 08:06
Legacy Id: TEC617163
Products:
CA IT Asset Manager , CA Software Asset Manager (CA SAM) , ASSET PORTFOLIO MGMT- SERVER , SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager
Issue/Introduction:

  • CA SDM with Oracle DBMS leverages bind variables in insert and update operations. In addition, for queries/updates in most stored procedures, bind variables are leveraged.
  • Our Oracle "select" queries do not generally use bind variables. This is related to problems faced with case-insensitive searches in earlier releases of Oracle. We have not observed any negative performance impact because of the same.

Incase there are specific queries that are in need of concern, you could engage CA Support for additional help on the same.

Environment:

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component: