Difference between revisions of "SPOutputParams"

From GreenVulcano Wiki
Jump to: navigation, search
Line 2: Line 2:
  
 
* Description;
 
* Description;
* SPOutputParam(+).
+
* SPOutputParam(s).
  
  
Line 9: Line 9:
 
This element defines an output parameter of the store procedure. It has as parameters:
 
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;
+
* ''type'': This attribute identifies the type of the output parameter. <br/>DataTypes: string|int|long|float|date|binary|blob|clob;
* position: defines the position that the parameter has in the statement;
+
* ''position'': defines the position that the parameter has in the statement;
  
 
and one subelement
 
and one subelement
  
 
* Description.
 
* Description.

Revision as of 13:38, 26 January 2012

This element defines the set of output parameters from the store procedure. It has two subelement:

  • Description;
  • SPOutputParam(s).


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.
    DataTypes: string|int|long|float|date|binary|blob|clob;
  • position: defines the position that the parameter has in the statement;

and one subelement

  • Description.