My Oracle Support Banner

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:

Oracle Life Sciences 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 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

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
Changes
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.