ORA-02095: specified initialization parameter cannot be modified

[skrisku]

Hi,

I am trying to execute the following and getting the below error,

>BEGIN
2 EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1''';
3 UTL_MAIL.send(sender => 'oracle@ATHR',
4 recipients => 'krishna.kumar.s@corp.aol.com',
5 subject => 'Test Mail',
6 message => 'Hello World',
7 mime_type => 'text; charset=us-ascii');
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
ORA-06512: at line 2

Can someone throw some light on this.

Thanks,

KK

[davey23uk]

version?

[vnktummala]

'ALTER SESSION SET smtp_out_server = ''127.0.0.1'''

SMTP_OUT_SERVER is not modifiable dynamically.

Please check the below link.

http://download.oracle.com/docs/cd/B...1.htm#i1134036

Thanks,