Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_subprograms001.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"> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </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" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-04-21T9:46:24Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Stored Subprograms" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10766-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="prev" href="tdddg_subprograms.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_subprograms002.htm" title="Next" type="text/html" /> <title>About Stored Subprograms</title> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <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="tdddg_subprograms.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_subprograms002.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHGDECD" name="CIHGDECD"></a><a id="TDDDG48000" name="TDDDG48000"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>About Stored Subprograms</h1> <a name="BEGIN" id="BEGIN"></a> <p>A <a id="sthref306" name="sthref306"></a><span class="bold">subprogram</span> is a PL/SQL unit that consists of SQL and PL/SQL statements that solve a specific problem or perform a set of related tasks. A subprogram can have parameters, whose values are supplied by the invoker. A subprogram can be either a <a id="sthref307" name="sthref307"></a>procedure or a <a id="sthref308" name="sthref308"></a>function. Typically, you use a procedure to perform an action and a function to compute and return a value.</p> <p>A <a id="sthref309" name="sthref309"></a><a id="sthref310" name="sthref310"></a><span class="bold">stored subprogram</span> is a subprogram that is stored in the database. Because they are stored in the database, stored programs can be used as building blocks for many different database applications. (A subprogram that is declared within another subprogram, or within an anonymous block, is called a <span class="bold">nested subprogram</span> or <a id="sthref311" name="sthref311"></a><a id="sthref312" name="sthref312"></a><span class="bold">local subprogram</span>. It cannot be invoked from outside the subprogram or block in which it is declared. An <a id="sthref313" name="sthref313"></a><a id="sthref314" name="sthref314"></a><a id="sthref315" name="sthref315"></a><span class="bold">anonymous block</span> is a block that is not stored in the database.)</p> <p>There are two kinds of stored subprograms:</p> <ul> <li> <p><a id="sthref316" name="sthref316"></a><span class="bold">Standalone stored subprogram</span>, which is created at schema level</p> </li> <li> <p><a id="sthref317" name="sthref317"></a><a id="sthref318" name="sthref318"></a><span class="bold">Packaged subprogram</span>, which is created inside a package</p> </li> </ul> <p>Standalone stored subprograms are useful for testing pieces of program logic, but when you are sure that they work as intended, Oracle recommends that you put them into packages.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=CNCPT1776','newWindow').focus()"><span class="italic">Oracle Database Concepts</span></a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=LNPLS008','newWindow').focus()"><span class="italic">Oracle Database PL/SQL Language Reference</span></a></p> <p><a href="tdddg_subprograms.htm#CIHDFDJG">Developing Stored Subprograms and Packages</a></p> </div> </div> <!-- class="sect1" --> <!-- 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 © 1996, 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="tdddg_subprograms.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_subprograms002.htm"><img width="24" height="24" 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