How To Enable/Disable Via PL/SQL The LSH Profile "Use Character Semantics for Workarea" (LSH_USE_CHAR_SEMANTICS)

(Doc ID 2422911.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

How to update this profile value via PL/SQL instead of launching EBS profile Form?
Name: LSH: Use Character Semantics for Workarea Installation
Site: No or Yes are the valid values

CRITICAL: Apply it carefully. If you already have loaded data in the tables, you will loss it if you change from NO to YES. Usually, you perform this change before loading data on PRODUCTION.

REFERENCE: https://docs.oracle.com/cd/E54418_01/doc.24/e52195.pdf => "Using Character Semantics for Work Area Table Installation".

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms