Oracle Alert Help

Hello all !

I hope you can help. I have an Oracle Alert that makes a simple select from a table containing a LONG datatype column ;

   SELECT EMAIL,
          CHK_ID,
          CHK_AMT_NUM,
          CHK_AMT_CHAR,
          CHK_DATE,
          ACCT,
          ALERT_FLAG,
          INVOICE
     INTO &email,
          &chk_id,
          &chk_amt_num,
          &chk_amt_char,
          &chk_date,
          &acct,
          &alert_flag,
          &invoice           
     FROM test_table
 ORDER BY chk_id

The INVOICE field is the one that is the LONG field and contains 270 lines of data. However when I run the alert the email message returned only lists 73 lines ;

*** THIS IS AN AUTOMATED MESSAGE - PLEASE DO NOT REPLY. Should you have any questions regarding this claim, please contact the Accounts Payable Centre