This content has been marked as final. Show 3 replies
Have a look at the package specification of htmldb_mail.
-- Parameters p_smtp_hostname and p_smtp_portno remain for backward
-- compatibility. But they are ignored. The SMTP host name and
-- parameter are exclusively derived from system preferences
-- when sending mail.
procedure push_queue( p_smtp_hostname in varchar2 default null,
p_smtp_portno in varchar2 default null );
You can check the setting of system preferences by executing the following queries:
SELECT #OWNER#.wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS') FROM dual;
Replace #OWNER# by the FLOWS schema i.e. FLOWS_020100.
I suggest do not install the scripts, but try to send email with your current configuration.
Thanks, I'll check this.
Do you know if the package can work on Oracle 9 versions or if it requiers Oracle 10?