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 MARCH 08, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms