Make sure you have the DB Mail console running and you have configured the database connection and the appropriate email interface. : how does this work. I have downloaded the trial version. Installed it.
: created the send_mail function in the system user and created a public
: profile. Also tested as per the select statement what is given alongwith
: the software, and it returned '0' zero. : I had tried : SELECT send_mail('nthakkar@saberconsulting.com',
: 'Test message',
: 'DB Mail has been successfully installed',
: 'nthakkar@saberconsulting.com' )
: FROM dual : and it returned zero. Now I was expecting that it would send a mail to
: "nthakkar@saberconsulting.com" as it had asked in the DB Mail
: configuration for the SMTP server and it had been configured as well. : BUT it didnt send the mail to my email addr!!!! : Could anybody clarify its working methodology. Like would it send a mail from
: the Database to my email account or IT WOULD JUST CREATE A PIPE IN THE
: DATABASE WHICH CAN BE READ ONLY USING THE DBMS_PIPE PACKAGE??! : Thanks
: Nitin Thakkar
: nthakkar@saberconsulting.com
|
