Forum Stats

  • 3,875,396 Users
  • 2,266,910 Discussions


Listagg separator is not working when used in OEM, same has been working on SQl prompt

Hi All, i've used 'listagg(output, chr(10)) within group ( order by output) as LOG' it is working on sql prompt but not working when i've used this in OEM metric.

FYI, the requirement here is to send the log column as an email alert from OEM.

can anyone please help me here ? I've tried multiple options but none of them seems to be working.

The data is being interpreted in http format in mail sent by OEM.

Thanks in advance.