DB Upgrade Issue LAM_PATIENT.STUDY_PATIENT_ID
Last updated on JUNE 10, 2013
Applies to:Oracle Argus Safety - Version 7.0.1 and later
Information in this document applies to any platform.
Column LAM_PATIENT.STUDY_PATIENT_ID has a length of 20 in V 5.0.5 and in V 7.0.2 as well.
Migration script path:
\Previous Database Upgrades\Database_released_code_701_from_5052\Database_released_code_51\DBInstaller\Upgrades\UPGRADE_TO_51\SQL
ALTER TABLE &USER..LAM_PATIENT MODIFY (STUDY_PATIENT_ID VARCHAR2(10 CHAR));
Since we have more than 10 char in this field the statement above fails.
The first statement seems to be redundant. The second statement should be corrected to:
ALTER TABLE &USER..LAM_PATIENT MODIFY (STUDY_PATIENT_ID VARCHAR2(20 CHAR));
Please confirm if this is an issue with the DB upgrade scripts.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms