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 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.