Getting "System.Exception: EXC000 ---> System.Data.OracleClient.OracleException: ORA-00936: missing expression" Error When Saving a Study (Doc ID 1353600.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Getting the below error when adding a Who Drug with no ingredients to the study and saving it:

/Argus Console/BusinessConfig/ProjectStudyProduct.aspx
System.Exception: EXC000 ---> System.Data.OracleClient.OracleException: ORA-00936: missing expression
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_BUS_CONFIG", line 6292
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_BUS_CONFIG", line 1662
ORA-06512: at line 1

Steps to Repeat:

 1. Create a Study with one company drug
 2. Add the Who Drug to the Study:
      Trade Name: GLUCOCORTICOIDS, ATC Code: H02AB, Drug Code:
      900392.01.001, ATC Description: GLUCOCORTICOIDS
 3. Save it (if you do not get the error at this point then continue steps 4
 and 5)
 4. Add the Who Drug to the Study:
   Trade Name: GLUCOCORTICOSTEROIDS, ATC Code: H02AB, Drug Code:
  900271.01.001, ATC Description: GLUCOCORTICOIDS
  5. Save it
  6. Observe that system throws the "ORA-00936: missing expression" error

Changes

Cause

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