"ORA-00933: SQL command not properly ended" Exception on Direct SQL Update Agent Action (Doc ID 1931371.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Transportation Management - Version 6.3.0 and later
Information in this document applies to any platform.

Symptoms

Insert statement works fine from backend by using SQL*Plus, but fails from Direct SQL Update Agent Action due to ORA-00933 exception.


-- Error Message:
Error  Exception  insert into table_name(...skip...) returning (...skip...) into ?,?,?,?; [...skip...]
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeUpdate(SqlPreparedStatement.java:36)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:252)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:168)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:93)
at glog.server.agent.utility.DBUpdate.execute(DBUpdate.java:252)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:49)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:40)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(Unknown Source)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:356)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:145)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:100)
at glog.util.event.EventThread.run(EventThread.java:86)
at java.lang.Thread.run(Thread.java:680)


REPRODUCE STEPS
----------------------
1. Create new agent and add direct sql update action like following SQL Statement:

insert into table_name(...skip...) select ...skip from dual where ...skip...

2. Do some steps to perform the agent action.
3. View Log, notice the ORA-00933 error is occurred.

Changes

This issue is occurred after upgrading to 6.3 version. 

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