Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util037.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>GET_FILE Procedure</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:16Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="GET_FILE Procedure" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-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" title="Home" type="text/html" /> <link rel="up" href="apex_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="up" href="apex_util037.htm" title="GET_FILE Procedure" type="text/html" /> <link rel="prev" href="apex_util036.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util038.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_util.htm" title="APEX_UTIL">APEX_UTIL</a> > GET_FILE Procedure</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="apex_util036.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util038.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDHEEAF" name="CHDHEEAF"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI133" id="AEAPI133"></a>GET_FILE <a id="sthref202" name="sthref202"></a><a id="sthref203" name="sthref203"></a>Procedure</h1> <p>This procedure downloads files from the Oracle Application Express file repository. Please note if you are invoking this procedure during page processing, you must ensure that no page branch will be invoked under the same condition, as it will interfere with the file retrieval. This means that branches with any of the following conditions should not be set to fire:</p> <ul> <li> <p>Branches with a 'When Button Pressed' attribute equal to the button that invokes the procedure.</p> </li> <li> <p>Branches with conditional logic defined that would succeed during page processing when the procedure is being invoked.</p> </li> <li> <p>As unconditional.</p> </li> </ul> <a id="sthref204" name="sthref204"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.GET_FILE ( p_file_id IN VARCHAR2, p_inline IN VARCHAR2 DEFAULT 'NO'); </pre> <a id="sthref205" name="sthref205"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDFEBDG">Table: GET_FILE Parameters</a> describes the parameters available in <code>GET_FILE</code> procedure.</p> <div class="tblformal"><a id="sthref206" name="sthref206"></a><a id="CHDFEBDG" name="CHDFEBDG"></a> <p class="titleintable">GET_FILE Parameters</p> <table class="Formal" title="GET_FILE Parameters" summary="This table describes the parameters available in the GET_FILE procedure." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="20%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t55">Parameter</th> <th align="left" valign="bottom" id="r1c2-t55">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t55" headers="r1c1-t55"> <p><code>p_file_id</code></p> </td> <td align="left" headers="r2c1-t55 r1c2-t55"> <p>ID in <code>APEX_APPLICATION_FILES</code> of the file to be downloaded. <code>APEX_APPLICATION_FILES</code> is a view on all files uploaded to your workspace. The following example demonstrates how to use <code>APEX_APPLICATION_FILES</code>:</p> <pre xml:space="preserve" class="oac_no_warn"> DECLARE l_file_id NUMBER; BEGIN SELECT id INTO l_file_id FROM APEX_APPLICATION_FILES WHERE filename = 'myxml'; -- APEX_UTIL.GET_FILE( p_file_id => l_file_id, p_inline => 'YES'); END; </pre></td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t55" headers="r1c1-t55"> <p><code>p_inline</code></p> </td> <td align="left" headers="r3c1-t55 r1c2-t55"> <p>Valid values include <code>YES</code> and <code>NO</code>. <code>YES</code> to display inline in a browser. <code>NO</code> to download as attachment</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref207" name="sthref207"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>GET_FILE</code> function to return the file identified by the ID 8675309. This will be displayed inline in the browser.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN APEX_UTIL.GET_FILE( p_file_id => '8675309', p_inline => 'YES'); END; </pre> <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">See Also:</p> <a href="apex_util038.htm#CHDICJGD">"GET_FILE_ID Function"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="refsect1" --> <!-- 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="apex_util036.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util038.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