Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\advnc_blob_reports.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About BLOB Support in Reports</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:32Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About BLOB Support in Reports" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="advnc.htm" title="Advanced Programming Techni..." type="text/html" /> <link rel="up" href="advnc_blob.htm" title="About BLOB Support in Forms..." type="text/html" /> <link rel="up" href="advnc_blob_reports.htm" title="About BLOB Support in Reports" type="text/html" /> <link rel="prev" href="advnc_blob_forms.htm" title="Previous" type="text/html" /> <link rel="next" href="advnc_blob_methods.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="advnc.htm" title="Advanced Programming Techni...">Advanced Programming Techni...</a> > <a href="advnc_blob.htm" title="About BLOB Support in Forms...">About BLOB Support in Forms...</a> > About BLOB Support in Reports</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="advnc_blob_forms.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_blob_methods.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCGBCHBD" name="BCGBCHBD"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25908" id="HTMDB25908"></a>About BLOB <a id="sthref2287" name="sthref2287"></a>Support in Reports</h1> <p>Oracle Application Express includes <code>BLOB</code> support for both classic and interactive reports. If you use a wizard to create a report and include a column of type <code>BLOB</code>, basic support will be included. Additional information should be added after generation to make the download capability more user friendly.</p> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref2288" name="sthref2288"></a> <h2><a name="HTMDB25909" id="HTMDB25909"></a>Providing a Download Link</h2> <p>To facilitate the inclusion of a download link in a report, the report includes the selection of the length of the <code>BLOB</code> (for example, <code>dbms_lob.getlength(RESUME)</code>). If the length is 0, the <code>BLOB</code> is <code>NULL</code> and no download link is displayed. In the same way you specify a format mask for a date or number you can format a download link. The DOWNLOAD format is more complex however then other format masks in that you are required to specify at least three parameters, for example:</p> <pre xml:space="preserve" class="oac_no_warn"> DOWNLOAD:EMP:RESUME:EMPNO </pre> <p>The parameters of the DOWNLOAD format are described in the following table:</p> <div class="inftblinformal"> <table class="Informal" title="Download Format Parameters" summary="This table describes the parameters of the DOWNLOAD format." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="9%" /> <col width="23%" /> <col width="15%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t27">Position</th> <th align="left" valign="bottom" id="r1c2-t27">Attribute</th> <th align="left" valign="bottom" id="r1c3-t27">Required</th> <th align="left" valign="bottom" id="r1c4-t27">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t27" headers="r1c1-t27">1</td> <td align="left" headers="r2c1-t27 r1c2-t27">DOWNLOAD</td> <td align="left" headers="r2c1-t27 r1c3-t27">Yes</td> <td align="left" headers="r2c1-t27 r1c4-t27">Identifies the DOWNLOAD report format mask.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t27" headers="r1c1-t27">2</td> <td align="left" headers="r3c1-t27 r1c2-t27">Table Name</td> <td align="left" headers="r3c1-t27 r1c3-t27">Yes</td> <td align="left" headers="r3c1-t27 r1c4-t27">Case sensitive name of table containing target column of type <code>BLOB</code>.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t27" headers="r1c1-t27">3</td> <td align="left" headers="r4c1-t27 r1c2-t27">Column containing BLOB</td> <td align="left" headers="r4c1-t27 r1c3-t27">Yes</td> <td align="left" headers="r4c1-t27 r1c4-t27">Case sensitive name of column of type <code>BLOB</code>.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t27" headers="r1c1-t27">4</td> <td align="left" headers="r5c1-t27 r1c2-t27">Primary Key Column 1</td> <td align="left" headers="r5c1-t27 r1c3-t27">Yes</td> <td align="left" headers="r5c1-t27 r1c4-t27">Case sensitive name of primary key column 1.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t27" headers="r1c1-t27">5</td> <td align="left" headers="r6c1-t27 r1c2-t27">Primary Key Column 2</td> <td align="left" headers="r6c1-t27 r1c3-t27">No</td> <td align="left" headers="r6c1-t27 r1c4-t27">Case sensitive name of primary key column 2.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t27" headers="r1c1-t27">6</td> <td align="left" headers="r7c1-t27 r1c2-t27">MIME type Column</td> <td align="left" headers="r7c1-t27 r1c3-t27">No</td> <td align="left" headers="r7c1-t27 r1c4-t27">Case sensitive column name used to store the <code>MIME</code> type.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t27" headers="r1c1-t27">7</td> <td align="left" headers="r8c1-t27 r1c2-t27">Filename Column</td> <td align="left" headers="r8c1-t27 r1c3-t27">No</td> <td align="left" headers="r8c1-t27 r1c4-t27">Case sensitive column name used to store the filename of the <code>BLOB</code>. If <code>NULL</code>, the column name is used as the default when a user downloads the file.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t27" headers="r1c1-t27">8</td> <td align="left" headers="r9c1-t27 r1c2-t27">Last Update Column</td> <td align="left" headers="r9c1-t27 r1c3-t27">No</td> <td align="left" headers="r9c1-t27 r1c4-t27">Case sensitive column name used to store the last update date of the <code>BLOB</code>. If used, the HTTP header of the file download indicates the date of last modification and Web browsers will be able to cache the <code>BLOB</code>. If not specified, the browser may not be able to cache files.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t27" headers="r1c1-t27">9</td> <td align="left" headers="r10c1-t27 r1c2-t27">Character Set Column</td> <td align="left" headers="r10c1-t27 r1c3-t27">No</td> <td align="left" headers="r10c1-t27 r1c4-t27">Case sensitive column name used to store the character set of the <code>BLOB</code>. Most relevant for Asian languages which may need to maintain the character set encoding.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t27" headers="r1c1-t27">10</td> <td align="left" headers="r11c1-t27 r1c2-t27">Content Disposition</td> <td align="left" headers="r11c1-t27 r1c3-t27">No</td> <td align="left" headers="r11c1-t27 r1c4-t27">Specify <code>inline</code> or <code>attachment</code>. All other values ignored. If a <code>MIME</code> type is provided and the file is a type that can be displayed, the file will be displayed. If <code>MIME</code> type is not provided, or the file cannot be displayed inline, the user will be prompted to download.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t27" headers="r1c1-t27">11</td> <td align="left" headers="r12c1-t27 r1c2-t27">Download Text</td> <td align="left" headers="r12c1-t27 r1c3-t27">No</td> <td align="left" headers="r12c1-t27 r1c4-t27">String used for the download link. If nothing provided, <code>Download</code> is used. Note that this will support substitutions (useful for translated applications).</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --> <p>Consider the following example:</p> <pre xml:space="preserve" class="oac_no_warn"> DOWNLOAD:EMP:RESUME:EMPNO::RESUME_MIMETYPE:RESUME_FILENAME:RESUME_LAST_UPDATE::attachment:Resume </pre> <p>If you have a report column with a format mask that begins with <code>DOWNLOAD:</code>, you will see a link below the format 'BLOB Download Format Mask'. This popup assists in entering all the parameters necessary for the DOWNLOAD format.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Tip:</p> To see a real example, go to Sample Application, page 29 (Master Detail), Items for Order #&P29_ORDER_ID. region, Product Image column. See <a href="demo.htm#CEGIBAGC">"Running a Demonstration Application"</a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref2289" name="sthref2289"></a> <h2><a name="HTMDB25910" id="HTMDB25910"></a>Displaying the BLOB</h2> <p>If the <code>BLOB</code> you are working with is an image, you can display it in the report as well. To do this, you use the new report format mask of 'IMAGE'. Regardless of the <code>MIME</code> type, the report will always attempt to display the BLOB. If the BLOB cannot be rendered, a broken image will be displayed.</p> <p>The parameters of the IMAGE format mask are described in the following table:</p> <div class="inftblinformal"> <table class="Informal" title="Image Format Mask Parameters" summary="This table describes the parameters of the IMAGE format." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="13%" /> <col width="15%" /> <col width="15%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t29">Position</th> <th align="left" valign="bottom" id="r1c2-t29">Attribute</th> <th align="left" valign="bottom" id="r1c3-t29">Required</th> <th align="left" valign="bottom" id="r1c4-t29">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t29" headers="r1c1-t29">1</td> <td align="left" headers="r2c1-t29 r1c2-t29">IMAGE</td> <td align="left" headers="r2c1-t29 r1c3-t29">Yes</td> <td align="left" headers="r2c1-t29 r1c4-t29">Identifies the IMAGE report format mask.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t29" headers="r1c1-t29">2</td> <td align="left" headers="r3c1-t29 r1c2-t29">Table Name</td> <td align="left" headers="r3c1-t29 r1c3-t29">Yes</td> <td align="left" headers="r3c1-t29 r1c4-t29">Case sensitive name of table containing target column of type <code>BLOB</code>.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t29" headers="r1c1-t29">3</td> <td align="left" headers="r4c1-t29 r1c2-t29">Column containing BLOB</td> <td align="left" headers="r4c1-t29 r1c3-t29">Yes</td> <td align="left" headers="r4c1-t29 r1c4-t29">Case sensitive name of column of type <code>BLOB</code>.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t29" headers="r1c1-t29">4</td> <td align="left" headers="r5c1-t29 r1c2-t29">Primary Key Column 1</td> <td align="left" headers="r5c1-t29 r1c3-t29">Yes</td> <td align="left" headers="r5c1-t29 r1c4-t29">Case sensitive name of primary key column 1.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t29" headers="r1c1-t29">5</td> <td align="left" headers="r6c1-t29 r1c2-t29">Primary Key Column 2</td> <td align="left" headers="r6c1-t29 r1c3-t29">No</td> <td align="left" headers="r6c1-t29 r1c4-t29">Case sensitive name of primary key column 2.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t29" headers="r1c1-t29">6</td> <td align="left" headers="r7c1-t29 r1c2-t29">MIME type Column</td> <td align="left" headers="r7c1-t29 r1c3-t29">No</td> <td align="left" headers="r7c1-t29 r1c4-t29">Case sensitive column name used to store the <code>MIME</code> type.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t29" headers="r1c1-t29">7</td> <td align="left" headers="r8c1-t29 r1c2-t29">Filename Column</td> <td align="left" headers="r8c1-t29 r1c3-t29">No</td> <td align="left" headers="r8c1-t29 r1c4-t29">Not used for IMAGE format but left in so that the format can easily be changed between IMAGE and DOWNLOAD.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t29" headers="r1c1-t29">8</td> <td align="left" headers="r9c1-t29 r1c2-t29">Last Update Column</td> <td align="left" headers="r9c1-t29 r1c3-t29">No</td> <td align="left" headers="r9c1-t29 r1c4-t29">Case sensitive column name used to store the last update date of the <code>BLOB</code>. If used, the HTTP header of the file download indicates the date of last modification and Web browsers will be able to cache the <code>BLOB</code>. If not specified, the browser may not be able to cache files.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t29" headers="r1c1-t29">9</td> <td align="left" headers="r10c1-t29 r1c2-t29">Character Set Column</td> <td align="left" headers="r10c1-t29 r1c3-t29">No</td> <td align="left" headers="r10c1-t29 r1c4-t29">Not used for IMAGE format but left in so that the format can easily be changed between IMAGE and DOWNLOAD.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t29" headers="r1c1-t29">10</td> <td align="left" headers="r11c1-t29 r1c2-t29">Content Disposition</td> <td align="left" headers="r11c1-t29 r1c3-t29">No</td> <td align="left" headers="r11c1-t29 r1c4-t29">Not used for IMAGE format but left in so that the format can easily be changed between IMAGE and DOWNLOAD.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t29" headers="r1c1-t29">11</td> <td align="left" headers="r12c1-t29 r1c2-t29">Alt Text</td> <td align="left" headers="r12c1-t29 r1c3-t29">No</td> <td align="left" headers="r12c1-t29 r1c4-t29">String used for the alt tag associated with the image.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --> <p>Consider the following example:</p> <pre xml:space="preserve" class="oac_no_warn"> IMAGE:EMP:RESUME:EMPNO::RESUME_MIMETYPE:RESUME_FILENAME:RESUME_LAST_UPDATE::attachment:Resume </pre> <p>If you have a report column with a format mask that begins with 'IMAGE:', you will see a link below the format 'BLOB Download Format Mask'. This popup assists in entering all the parameters necessary for the IMAGE format.</p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="advnc_blob_forms.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_blob_methods.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de