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

Last updated on MARCH 10, 2013

Applies to:

Oracle Argus Safety - Version 5.0.3.1 and later
Information in this document applies to any platform.
***Review currency on 10-Mar-2013***

Symptoms

Getting the below error when adding the Who Drug that do not have any 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms