My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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:



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

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.