User talk:Krishnamca198

I have an issue like this. I have an e-mail program (PL/SQL stored procedure running on oracle 11 g standard editions) which sends e-mails using UTL_SMTP. Brief code is: IF V_SMS_VENDOR = 'SMS' THEN SP_SEND_MAIL (pi_CAMPAIGN_ID,V_SMS_VENDOR,V_SMS_ID); END IF;

IF V_OBD_VENDOR ='OBD' THEN SP_SEND_MAIL (pi_CAMPAIGN_ID,V_OBD_VENDOR,V_OBD_ID); END IF;

IF V_SANCHAYA_VENDOR ='SANCHAYA' THEN SP_SEND_MAIL (pi_CAMPAIGN_ID,V_SANCHAYA_VENDOR,V_SANCHAYA_ID); END IF; SP_SEND_MAIL procedure sends mail based on condition. When above code is executed for all vendor (SMS, OBD, SANCHAYA), sometimes mail is received for all vendors, sometimes for any one or any two or even not for any vendor. The DB is on Linux. What could be the problem here? Any help would be greatly appreciated.