You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by sc...@apache.org on 2007/02/15 20:58:33 UTC
svn commit: r508113 - /db/derby/docs/trunk/src/ref/rrefcallprocedure.dita
Author: scotsmatrix
Date: Thu Feb 15 11:58:32 2007
New Revision: 508113
URL: http://svn.apache.org/viewvc?view=rev&rev=508113
Log:
DERBY-2137: Updates the syntax for the CALL (PROCEDURE) statement. Patch submitted by Kim Haase.
Modified:
db/derby/docs/trunk/src/ref/rrefcallprocedure.dita
Modified: db/derby/docs/trunk/src/ref/rrefcallprocedure.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcallprocedure.dita?view=diff&rev=508113&r1=508112&r2=508113
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcallprocedure.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcallprocedure.dita Thu Feb 15 11:58:32 2007
@@ -17,7 +17,7 @@
-->
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
<reference xml:lang="en-us" id="rrefcallprocedure">
-<title>CALL (PROCEDURE)</title>
+<title>CALL (PROCEDURE) statement</title>
<prolog><metadata>
<keywords>
</keywords>
@@ -27,13 +27,13 @@
<section><p>The CALL (PROCEDURE) statement is used to call procedures. A call to a
procedure does not return any value.</p></section>
<section><title>Syntax</title>
-<codeblock><b>CALL <xref href="rrefcreateprocedurestatement.dita#rrefcreateprocedurestatement/rrefcrproprocedurename">procedure-Name</xref> ( [ ? [, ?]* ] )
+<codeblock><b>CALL <i><xref href="rrefcreateprocedurestatement.dita#rrefcreateprocedurestatement/rrefcrproprocedurename">procedure-Name</xref></i> ( [ <varname>expression</varname> [, <varname>expression</varname>]* ] )
</b></codeblock></section>
<section><title>Example</title>
<codeblock><b>CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
-IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
-PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
-'com.acme.sales.calculateRevenueByMonth';
+ IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
+ PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
+ 'com.acme.sales.calculateRevenueByMonth';
CALL SALES.TOTAL_REVENUE(?,?,?);
</b></codeblock></section>
</refbody></reference>