Complex Data Type Support for Operations¶
The IFS OData Provider supports complex parameter types and return types in actions and functions. This section covers details about the usage and limitations of such complex parameter types and return types.
Supported Data Types for Attributes in Complex Data Types¶
OData operations support complex data types with attributes of simple, complex, and collection. Below is a list of supported data types within complex data types.
- Alpha
- Boolean
- Date
- Enumeration
- GUID
- Integer
- Number
- Text
- Time
- Timestamp
- Array
Calling Odata Operations with Complex Data Type Parameters and Return Types¶
Challenges and Solutions¶
- It is possible to change the attribute arrangement of a Complex Data Type as you wish by adding/removing attributes or changing the order of the attributes.
- With these changes, the cached JDBC Complex Data Type descriptor becomes stale.
- So in this case according to oracle, it throws an SQL exception.
Click here for Oracle documentation.
- Forcefully creating the structure descriptor is deprecated from oracle 12c onwards due to some performance issues.
- So in this scenario, we mark the sql connection to be destroyed by the connection pool and throw an exception as below to inform the client.
