CODEWITHSUNDEEP
oracle-databaseemailplsqlbitstuffingformatmessage
Hashka
Hashka

Reputation: 445

utl_lms.format_message | PL/SQL | URL correct in <a> but dot is missing in href

I'm trying to send a mail with a link inside.

l_url := 'https://example.test.com/';
l_body :=  utl_lms.format_message('<body><a href="%s">%s</a></body>', l_url, l_url);

But here's what I have as result :

<body><a href="https://example.testcom/">https://example.test.com/</a></body>

Why the "." is missing in the href...?

UPDATE

I have countered this problem. It works, but it doesn't solve it.

l_url := 'https://example.test..com/';
l_body :=  utl_lms.format_message('<body><a href="%s">%s</a></body>', l_url, replace(l_url, '..', '.'));

Result :

<body><a href="https://example.test.com/">https://example.test.com/</a></body>

Upvotes: 0

Views: 177

Answers (0)

Related Questions