"ORA-00933: SQL command not properly ended" Exception on Direct SQL Update Agent Action
(Doc ID 1931371.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 6.3.0 and later
Information in this document applies to any platform.
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:
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.
This issue is occurred after upgrading to 6.3 version.
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