Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Adapter Services | Configuring StoredProcedureWithSignature Services | Using Oracle Object or User-defined Data Type in StoredProcedureWithSignature Adapter Services
 
Using Oracle Object or User-defined Data Type in StoredProcedureWithSignature Adapter Services
The user-defined data types supported for the input and output parameters in StoredProcedureWithSignature are: simple object type, nested object type and array of object types.
User-defined data types
Input and Output Field Type
Description
Simple and Nested object type
Mapped to JDBC Type STRUCT.
The Input Field Type and Output Field Type supported for User-defined data types are java.lang.Object and IDATA, an object of com.wm.data.IData.
java.lang.Object
Input: Pass a single-dimensional object array as shown in the following example:
Object objType = new Object[]{1,"name"};
Output: Return value is a single-dimensional Object array.
IDATA
Input: Perform the following steps:
1. Create a Document Type with fields having names in uppercase.
2. Create an input field of type Document Reference using the Document Type created in step 1.
3. Map the input field created in step 2 to the input parameter passed to the adapter service of user-defined type parameter.
Output: Return value is a Document of type com.wm.data.IData.
Array of object type
Mapped to JDBC type ARRAY.
The Input Field Type and Output Field Type supported for User-defined data types are java.lang.Object and IDATA_ARRAY, an array object of com.wm.data.IData.
java.lang.Object
Input: Pass the value in a two-dimensional object array as shown in the following example:
Object objType = new Object[][]{{1,"name1"},{2,"name2"}};
Output: Return value is a two-dimensional Object array.
IDATA_ARRAY
Input: Perform the following steps:
1. Create a Document List with fields having names in uppercase.
2. Use the wm.adapter.wmjdbc.utils:docListToObject service to map the Document List to the Object.
3. Map the output value of the service from step 2 to the ARRAY parameter.
Output: Return value is an Object List of type com.wm.data.IData.