My Oracle Support Banner

'ORA-00933: SQL command not properly ended' Error When Generating Draft PMDA Device Form (Doc ID 2450253.1)

Last updated on DECEMBER 16, 2024

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1.2 and later
Oracle Life Sciences Argus Safety Japan - Version 8.1.2 and later
Oracle Life Sciences Argus Safety Cloud Service - Version 8.0 and later
Oracle Life Sciences Argus Safety Japan Cloud Service - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Running the Draft PMDA report using form 報告様式8:医療機器不具合・感染症症例報告書.

Get the following pop-up error:

Create Documentum COM object fail

Additional errors from PMDA_Device_Report_Error_Log.txt file:
ORA-00933: SQL command not properly ended
Stack Trace
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
  at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
  at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
  at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
  at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(IDbCommand command)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command)
  at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)


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


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