Difference between revisions of "SPOutputParams"

From GreenVulcano Wiki
Jump to: navigation, search
 
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(s).
 
  
 +
=={{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. <br/>DataTypes: string|int|long|float|date|binary|blob|clob;
+
===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]].

Latest revision as of 15:32, 3 April 2012

Description

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

GreenVulcano® ESB Configuration

Might contain the following sub-elements:


SPOutputParam

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: