How to re-configure Email in a Runtime Environment?

Frantisek Mika

I followed the documentation and configured emailing in a runtime environment. When the end user uploads an Interactive Report to the email, he receives it from the address which is the same as "to" address.

Even if I set and checked the SMTP_FROM and other parameters in the runtime environment, emailing does not work correctly.

Any advice?

First picture attached: user downloads data from the Interactive Report and sends it TO email address.

Second picture attached: incoming email approaches the right user with the TO email address, but FROM email address is identic as TO one. The FROM address differs from the address determined by

SELECT

APEX_INSTANCE_ADMIN.GET_PARAMETER('SMTP_FROM')

FROM DUAL;

Zprávu upravil(a): Frantisek Mika

martinbn

Hi Frantisek

I have defined "Default Email From Address" in the instance setup (INTERNAL).

When I do mail from interactive reports, this is the from address which is used. So basically it works fine in my APEX instance.

P.s. I am on version 5.0.2

Best Regards

Martin

Frantisek Mika

Hi Martin,

thanks for your sharing. You probably mention the development environment, am I right?

To configure email in the development internal instance setup is OK, works fine for me, too.

The problem is with configuration in the runtime environment, which is available only through sqlplus. do you have such an experience?

F.

Alexandra David-Oracle

Try using the following statement:

BEGIN

   APEX_INSTANCE_ADMIN.SET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);

END;

Reference:

https://docs.oracle.com/database/121/AEADM/adm_mg_service_set.htm#BABGEHGI

Regards,

Alexandra

martinbn

ok, youre right.

No - have not tried this in a runtime only env.

Short of using the API I cannot think of another option (other than finding the relevant APEX table in the installation and changing it directly) :-)

Brgds

Martin