Email XML as Attachment

Hi All,

I'm creating an XML which will be generated in a location that will be FTP'd later to a vendor. I would like to pick the XML file and send as an email to myself and some group.

The file name will have a Datestamp.  can i use Wildcard character in file name when defining in anyway.

Please suggest

CREATE OR REPLACE PROCEDURE SEND_HEADER   (pi_name   IN   VARCHAR2,pi_header   IN   VARCHAR2)

IS

v_src_loc  BFILE := BFILENAME('MY_FILES2', 'INVOICE_ONEOFF');

  l_buffer   RAW(54);

  l_amount   BINARY_INTEGER := 54;

  l_pos      INTEGER := 1;

  l_blob     BLOB := EMPTY_BLOB;