My Oracle Support Banner

Question Length increase (at DCM Level) is not reflected in LSH - why is this? (Doc ID 2833692.1)

Last updated on JANUARY 14, 2022

Applies to:

Oracle Clinical - Version 5.0.1 and later
Information in this document applies to any platform.

Goal

OC Question Length increase (at DCM Level) is not reflected in LSH - why is this? i.e.

i.
OC: OCCURAE Question Length at DCM Level is increased from 2 to 20.

ii.
OC: Data Extract Job has been run to reflect above change in the relevant view i.e. column length of the question increases from VARCHAR2(2) to VARCHAR2(20).

iii.
LSH: calls the below OC function (using remote DB link).  This procedure is returning the column value as 2 instead of 20: 

and the data type for the OCCURAE question shows as 2 in the LSH UI i.e.

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.