MAIL SENDING FROM ORACLE--hELP REQUIRED
pLEASE ADVICE ON THE BELOW MAIL FROM MY FRIEND..
THANKS VERY MUCH
Please go thro' this procedure in oracle pl/sql.This below procedure is not working. When i compile it , it is not giving any error. It is compiled successfully. But if i execute this procedure , it is hanging. Here database server and mail server are in different system. Please tell me what the problem is and how to proceed. 220.127.116.11 is our mail server ip address.
Expecting ur reply,
CREATE OR REPLACE PROCEDURE SP_SEND_MAIL (SENDER IN VARCHAR,RECEIPIENT IN VARCHAR,
MESSAGE IN VARCHAR)
use functions instead of procedures and get yourself some feedback as
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
I'm not sure if this will fix it, but you do not need the close_data() call when you use the data() function.
please check with your MAIL administrator and confirm the port # which is coded as 80 in following statement. If it is different please change.
Catch me online at Yahoo: ddpatel256
Click Here to Expand Forum to Full Width