ORA-02095: specified initialization parameter cannot be modified
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-02095: specified initialization parameter cannot be modified

  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Unhappy ORA-02095: specified initialization parameter cannot be modified

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    version?

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    '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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width