Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclecli.17.14.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Stored Procedure Results</title> <link rel="StyleSheet" href="css/oraclecli.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="oraclecli.17.01.html#559163">13 The Oracle Driver </a> : Stored Procedure Results</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="559163">Stored Procedure Results</a></div> <div class="Body"><a name="608887">When you enable the Procedure Returns Results connection option, the driver returns </a>result sets from stored procedures/functions. In addition, SQLGetInfo(SQL_MULT_RESULTS_SETS) returns Y and SQLGetInfo(SQL_BATCH_SUPPORT) returns SQL_BS_SELECT_PROC. If this option is enabled and you execute a stored procedure that does not return result sets, you incur a small performance penalty.</div> <div class="Body"><a name="608888">This feature requires that stored procedures be in a certain format. First, a package must be </a>created to define all of the cursors used in the procedure; then, the procedure can be created using the new cursor. For example:</div> <div class="syntax_first"><a name="608889">Create or replace package GEN_PACKAGE as </a></div> <div class="syntax"><a name="608890">CURSOR G1 is select CHARCOL from GTABLE2;</a></div> <div class="syntax"><a name="608891">type GTABLE2CHARCOL is ref cursor return G1%rowtype;</a></div> <div class="syntax"><a name="608892">end GEN_PACKAGE;</a></div> <div class="syntax"><a name="608893">Create or replace procedure GEN_PROCEDURE1 (</a></div> <div class="syntax"><a name="608894"> rset IN OUT GEN_PACKAGE.GTABLE2CHARCOL, icol INTEGER) as </a></div> <div class="syntax_first"><a name="608895">begin </a></div> <div class="syntax"><a name="608896"> open rset for select CHARCOL from GTABLE2</a></div> <div class="syntax"><a name="608897"> where INTEGERCOL <= icol order by INTEGERCOL;</a></div> <div class="syntax"><a name="608898">end;</a></div> <div class="Body"><a name="608899">When executing the stored procedures with result sets, do not include the result set </a>arguments (Oracle ref cursors) in the list of procedure parameters. The result set returned through the ref cursor is returned as a normal ODBC result set.</div> <div class="syntax_first"><a name="608900">{call GEN_PROCEDURE1 (?)}</a></div> <div class="Body"><a name="608901">where </a><span class="Syntax">?</span> is the parameter for the icol argument.</div> <div class="Body"><a name="608902">For more information, refer to your Oracle SQL documentation.</a></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de