Agent that Will Send the Full Error to a Contact uses Variable $error.message, this Results in the Following Error: Named bind variable $error.message not defined in: select substr('$error.message',1,100) from dual
(Doc ID 1522103.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.1.6 to 6.1.7 [Release 6.1]Information in this document applies to any platform.
Symptoms
On OTM version 6.1.6 when attempting to use an Agent where the Error tab is set with assign_variable it $ERR_MSG and then to use the variable in the notification, the following error occurs.
ERROR
-----------------------
Named bind variable $error.message not defined in: select substr('$error.message',1,100) from dual
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Set up an Agent where the error tab contains the saved query in the agent for the assign variable is:
select substr('$error.message',1,100) from dual
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 |
Cause |
Solution |
References |