Difference between revisions of "SPOutputParams"

Latest revision as of 15:32, 3 April 2012

SPOutputParams element defines the set of output parameters from the store procedure.

Might contain the following sub-elements:

This element defines an output parameter of the store procedure.

The following table shows its attributes:

Attribute	Type	Description
type	required	int\|long\|float\|date\|binary\|blob\|clob;
position	required	defines the position that the parameter has in the statement

Might contain the sub-element:

@@ Line 1: / Line 1: @@
-This element defines the set of output parameters from the store procedure. It has two subelement:
+==Description==
-* Description;
+SPOutputParams element defines the set of output parameters from the store procedure.
-* SPOutputParam(+).
+=={{GVESB}} Configuration==
-==SPOutputParam==
+Might contain the following sub-elements:
+* [[Description]]
+* [[#SPOutputParam|SPOutputParam]]
-This element defines an output parameter of the store procedure. It has as parameters:
-* type: This attribute identifies the type of the output parameter. See [[DataTypes]];
+===SPOutputParam===
-* position: defines the position that the parameter has in the statement;
-and one subelement
+This element defines an output parameter of the store procedure.
-* Description.
+The following table shows its attributes:
+{|class="gvtable"
+! Attribute !! Type !! Description
+|-
+| type || required || This attribute identifies the type of the output parameter. <br/>DataTypes: string|int|long|float|date|binary|blob|clob;
+|-
+| position || required || defines the position that the parameter has in the statement
+|}
+Might contain the sub-element:
+* [[Description]].