My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.