Database Administration (MOSC)

MOSC Banner

Problem sending attachment from database

edited Feb 7, 2010 8:14PM in Database Administration (MOSC) 7 commentsAnswered
Hi Guys,
Can anyone help me with this error?

 CREATE OR REPLACE PROCEDURE send_email (FileName IN VARCHAR2, AttachmentName IN VARCHAR2)
AS

   Attachment_Too_Large EXCEPTION;
   PRAGMA EXCEPTION_INIT (Attachment_Too_Large, -6502);

   FileHandle  BFILE;
   Buffer      RAW(32767);  
   Amount      INTEGER;
   Offset      INTEGER := 1;

BEGIN  

   FileHandle := BFILENAME('DUMP_DIR', FileName);
   Amount := DBMS_LOB.GETLENGTH(FileHandle);

   DBMS_OUTPUT.PUT_LINE('Attachment Size: ' || Amount || ' bytes');

   DBMS_LOB.FILEOPEN(FileHandle, DBMS_LOB.FILE_READONLY);
   DBMS_LOB.READ(FileHandle, Amount, Offset, Buffer);
   DBMS_LOB.FILECLOSE(FileHandle);

   UTL_MAIL.SEND_ATTACH_RAW(sender =>      'myemail@oracle.com',
                            recipients =>  'youremail@oracle.com',
                            subject =>     'Attachment Test',
                            message =>     'Test',
                            attachment =>   Buffer,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center