Problem sending attachment from database
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,
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,
0