New answers tagged oracle-10g-r2
Actually I did not even need to run 'ALTER SYSTEM SET smtp_out_server = new.server.com SCOPE = both'; I just passed the host name via xml and kept a default host name in config table in case the xml is blank.
Looking at the docs, you cannot selectively choose from multiple SMTP_OUT_SERVER values. Here's how that parameter works: http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams230.htm#REFRN10241 SMTP_OUT_SERVER specifies the SMTP host and port to which UTL_MAIL delivers out-bound E-mail. Multiple servers may be specified, separated by commas. ...
Top 50 recent answers are included