"ORA-00933: SQL command not properly ended" Exception on Direct SQL Update Agent Action
(Doc ID 1931371.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.3.0 and laterInformation 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 |