Unable to send a mail thru UTIL_SMTP ORA-24247
Using UTIL_SMTP thru oracle forms personalization as send_mail. And finding issue while submitting.
Form Name: PAXTREPE
Responsibility Name: Projects Implimentation Super User
1) Login into oracle apps
2) Go to responsibility --> Projects Implimentation Super User --> Expenditure Batches --> Enter
3) Enter the batch with the status of 'Working'
4) Click on 'Submit' button then it changes the status from 'Working' to 'Submitted'.
5) Then automatically sends an email to respective user thru UTIL_SMTP as a procedure and calling the same thru personalization.
Any idea on this to achieve to send mail thru stored procedure calling from personalization.
Thanks
satish