To make the XML schema as detailed as possible, the workbench needs to know the structure of these unchanging result sets. To find out this information, the workbench needs to run the stored procedure. Before the workbench can do so, you must provide the values of the input parameters.
For example, the operation "two_result_sets" calls a stored procedure that always accepts the same input values and always returns the same two result sets. If you do not provide the input values and run the stored procedure, the workbench creates the following default XML schema for the response message:
<xsd:element name="two_result_sets_Response"> <xsd:complexType> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" name="rowset" type="tns:anonymousResultSetType" /> <xsd:element maxOccurs="1" minOccurs="0" name="rowset2" type="tns:anonymousResultSetType" /> </xsd:sequence> </xsd:complexType> </xsd:element>
This XML schema does not contain information about columns or data types.
However, if you do provide the input values and then tell the workbench to run the stored procedure, the workbench generates this default XML schema for the response message:
<xsd:element name="two_result_setsResponse"> <xsd:complexType> <xsd:sequence> <xsd:element name="rowset"> <xsd:complexType> <xsd:sequence> <xsd:element maxOccurs="unbounded" minOccurs="0" name="row"> <xsd:complexType> <xsd:sequence> <xsd:element name="NAME" nillable="true" type="xsd:string" /> <xsd:element name="JOB" nillable="true" type="xsd:string" /> <xsd:element name="_x0033_" nillable="true" type="xsd:double" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="rowset2"> <xsd:complexType> <xsd:sequence> <xsd:element maxOccurs="unbounded" minOccurs="0" name="row"> <xsd:complexType> <xsd:sequence> <xsd:element name="NAME" nillable="true" type="xsd:string" /> <xsd:element name="JOB" nillable="true" type="xsd:string" /> <xsd:element name="_x0033_" nillable="true" type="xsd:double" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element>