hi due to the below

l_bfile := bfilename( 'MY_FILES', 'OTNToolbar.zip' );
9 dbms_lob.fileopen( l_bfile );

-------------------- you are able to execute this part of procedure -----------------
p_attachment_type => 'application/winzip',
16 p_attachment_file_name => 'OTNToolbar.zip');
-----------------------------------------------------------------------------------
In my scenario - I am not having any directory in my oracle database but i am having something like this
--------
SQL> desc quot_ole
Name Null? Type
------------------------------- -------- ----
QUOT_NUMBER VARCHAR2(30)
QUOT_OBJECT LONG RAW
-------
People save either word or pdf documents and unique quot_number like 'abc/2009' is assigned to each object inserted through FORMS 6i OLE Container
-----------------------------------------------------------------------------
How do i retrive this data for email - which is not having directory but either
mimetype=msword or mimetype=pdf and filename = as users push Word of pdf files inside.

if you can further modify this code to pull the information as per the suggested table above it will be of gr8 help for me to implement.

Otherwise i am able to receive email as per above with attachment.