Agent SQL Causes SQL Error When WHERE Gets Changed To HERE
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Management - Version: 5.5 to 5.5
This problem can occur on any platform.
-- Problem Statement:
When an Agent issues a Direct SQL Update with the following SQL
DELETE FROM SHIPMENT_REFNUM WHERE SHIPMENT_REFNUM_QUAL_GID = 'SYS REF_NOTIFY COVERING OFFICE' AND SHIPMENT_GID = $GID
2008-11-05 15:45:28.065 56387 Debug Sql DBUpdate: From the given SQL statement, couldn't decide on the entity for performing cache refresh.
Reason: Problems in executing the sub-query
ORA-00933: SQL command not properly ended
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms