Try OpenEdge Now
skip to main content
Web Services
Understanding WSDL Details : Defining TABLE-HANDLE (dynamic temp-table) parameters
 

Defining TABLE-HANDLE (dynamic temp-table) parameters

TABLE-HANDLE parameters pass both the schema and data, because the dynamic temp-table schema is not known at compile time. Thus, for TABLE-HANDLE parameters, OpenEdge Web services map an ABL TABLE-HANDLE to a <complexType> containing a sequence of xsd:any. There is a single definition used for all TABLE-HANDLE parameters in all supported SOAP formats. The following WSDL sample shows this common TABLE-HANDLE parameter definition:

TABLE-HANDLE definition for all dynamic temp-table parameters

<complexType name="TableHandleParam">
  <sequence>
    <any namespace="##local"/>
  </sequence>
</complexType>
The client application must create (for input) and parse (for output) the XML Schema along with the data for the parameter. How the client inserts the input schema and data in request messages and how it parses the output schema and data from response messages is entirely dependent on the client toolkit.
Each column of a TABLE-HANDLE row can hold any data type shown in the following table.

XML data types for TABLE-HANDLE parameter columns

ABL data type
XML Schema data type
CHARACTER
xsd:string
DATE
xsd:date
DATETIME-TZ
xsd:dateTime
DECIMAL
xsd:decimal
INT64
xsd:long
INTEGER (32 bit)
xsd:int
LOGICAL
xsd:boolean
RAW
xsd:base64Binary