2 Replies Latest reply: Mar 2, 2007 6:54 AM by 544305 RSS

    Getting bad argumnet error when using UTL_MAIL.SEND_ATTACH_VARCHAR2

    112497
      HI

      This is my code. I dont know what I am missing. Please advice. RK

      begin

      UTL_MAIL.SEND_ATTACH_VARCHAR2(
      sender => 'test@hotmail.com'
      ,recipients => 'test@yahoo.com'
      ,cc => null
      ,bcc => NULL
      ,subject => 'RE: Testing Attachment'
      ,message => 'Dear Providers: '
      || 'Let us know any changes in schedule'
      ,mime_type => 'text/plain; charset=us-ascii'
      ,priority => 1
      ,attachment => 'TEST'
      ,att_inline => TRUE
      ,att_mime_type => 'application_octet'
      ,att_filename => 'text.txt'
      );

      end;
      /

      ERROR at line 1:
      ORA-29261: bad argument
      ORA-06512: at "SYS.UTL_TCP", line 28
      ORA-06512: at "SYS.UTL_TCP", line 257
      ORA-06512: at "SYS.UTL_SMTP", line 116
      ORA-06512: at "SYS.UTL_SMTP", line 139
      ORA-06512: at "SYS.UTL_MAIL", line 228
      ORA-06512: at "SYS.UTL_MAIL", line 382
      ORA-06512: at line 3