[Home] [Help]
1592: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);
1593: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,
1594: clob_loc, doctype, attr_name);
1595: if (doctype is not null) then
1596: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
1597: end if;
1598: -- We have the document. Now determine the output method. HTML documents can be output as
1599: -- they are. Binary documents can only be downloaded
1600: if l_mime_type in (wf_notification.doc_text, wf_notification.doc_html) then
1624: -- Decode base64 encoded content
1625: if (upper(trim(l_encoding)) = 'BASE64') then
1626: dbms_lob.createTemporary(blob_loc, FALSE, dbms_lob.call);
1627:
1628: wf_mail_util.decodeBLOB(clob_loc, blob_loc);
1629: -- owa_util.mime_header(doctype, FALSE);
1630: -- Write appropriate headers before downloading the document
1631: if (l_filename is null or l_filename = '') then
1632: l_filename := aname || '.' || l_extension;
1657: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);
1658: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,
1659: blob_loc, doctype, attr_name);
1660: if (doctype is not null) then
1661: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
1662: end if;
1663: if (l_filename is null or l_filename = '') then
1664: l_filename := aname || '.' || l_extension;
1665: end if;