Prerequisites

• Windows workstation is available to load the WHODrug data.
• The system has Oracle client installed, including the following:

  SQLPLUS (Exe=sqlplus)
  SQL*Loader (Exe=sqlldr)

• There is an updated TNSNAMES file and Oracle client to connect to the Oracle Argus Safety database.
• The format of the WHO Drug Dictionary data files is Text and alternate rows are not blank.

  Note:

  WHODrug is loaded using sql*load with DIRECT=TRUE option. Because of sql*loader restrictions, no one should have access to the Oracle Argus Safety system while WHO-DRUG is being loaded.
• To display the WHO Drug Dictionary version in Oracle Argus Safety, the CFG_DICTIONARIES_GLOBAL.VERSION column fetches data from Version.txt file.

  If Version.txt file is missing during WHO Drug Dictionary load then WHO Drug Dictionary version is displayed based on the value available in CFG_DICTIONARIES.VERSION_NUMBER column only.