My Oracle Support Banner

Getting Error While Loading WHODD Chinese C3 March 2024 for Table WHO_DRUP_C_STRENGTH (Doc ID 3021707.1)

Last updated on JUNE 19, 2024

Applies to:

Oracle Life Sciences Argus Safety - Version 8.4 to 8.4.3 [Release 8.4]
Oracle Life Sciences Argus Safety Cloud Service - Version 8.4 to 8.4.3 [Release 8.4]
Information in this document applies to any platform.

Symptoms

While Loading WHO DD Chinese C3 March 2024 dictionary observed below:

The Load was completed without any error but while checking the counts for WHO dictionary tables,observed that table "who_drug_c_strength" is not getting populated with data i.e; count was zero .


Also, observed below error in Log (who_drug_c_strength.log)

SQL*Loader: Release 19.0.0.0.0 - Production on Wed XXX XX 07:09:00 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

SQL*Loader-350: Syntax error at line 9.
Expecting "," or ")", found "varchar2".
text varchar2(500)

Cause

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
Symptoms
Cause
Solution
References


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