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 laterInformation 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 |