The file was not attached. Make sure the specified file name is correct. Names are case sensitive on VMS. : Attachement retrieving error from DB Mail. : I created a directory in our VMS Oracle System scheama and give all previlege : to : the user scheama. : CREATE OR REPLACE DIRECTORY CTST AS '$DISK4:[CTST]' : After sending an attachment from PL/SQL, : DECLARE : ATTACH_ID INTEGER; : RET_CODE INTEGER; : BEGIN : ATTACH_ID := ATTACH_FILE(NULL,1,'RAJ_ATTACH.TXT','CTST'); : RET_CODE := send_mail('prajesh@dpa.co.ae', : 'test email by pnr','test email attachment from pl/sql by pnr', : 'prajesh@dpa.co.ae',null,1,attach_id); : end; : I am getting an error from DB Mail as follows. : Error retrieving attachments. Attachments ignored. : Tell me what is the problem? : Rajesh
|