can't use email adress (or any String with an @) in scheduler parameter
Description
if you try to add a scheduler param which contains an @, you will get an error (eg : with nmicoud@tgi.fr or @SQL=SELECT 'nmicoud@tgi.fr@ FROM DUAL , you will get "Env.parseContext: No second tag: tgi.fr")
Because the program search a second @ and did not find one.
The only workaround i find is to write the email like "nmicoud[at]tgi.fr" and in the process do the following : p_emails.replace("[at]", "@");
Perhaps it can be done also in the scheduler
WDYT ?
Nicolas
Environment
None
Activity
Show:
Nicolas Micoud March 12, 2015 at 8:00 AM
My mistake, it works Thanks Carlos
Nicolas Micoud March 11, 2015 at 2:00 PM
It worked ! ... but this notation cannot be used with a process
when using in a scheduler "@SQL=SELECT 'nmicoud'||chr(64)||'tgi.fr' FROM DUAL" => nmicoud@tgi.fr
but when using in a process, it is not interpreted and the program tries to send an email to a not valid address
Carlos Ruiz March 11, 2015 at 1:18 PM
, maybe an easier workaround is to try: @SQL=SELECT 'nmicoud'||chr(64)||'tgi.fr' FROM DUAL Can you please check it?
Major
if you try to add a scheduler param which contains an @, you will get an error (eg : with nmicoud@tgi.fr or @SQL=SELECT 'nmicoud@tgi.fr@ FROM DUAL , you will get "Env.parseContext: No second tag: tgi.fr")
Because the program search a second @ and did not find one.
The only workaround i find is to write the email like "nmicoud[at]tgi.fr" and in the process do the following :
p_emails.replace("[at]", "@");
Perhaps it can be done also in the scheduler
WDYT ?
Nicolas