Other Resources
Postgres as a Service
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
![]() |
![]() |
![]() |
8 Advanced JDBC Connector Functionality : 8.6 Using Object Types and Collections with Java : 8.6.2 Using a Collection
8.6.2 Using a CollectionListing 1.17-a is an SPL function that uses collection types NUMBER_ARRAY and CHAR_ARRAY as IN parameters and CHAR_ARRAY as the OUT parameter.The function concatenates the employee ID from the NUMBER_ARRAY IN parameter with the employee name in the corresponding row from the CHAR_ARRAY IN parameter. The resulting concatenated entries are returned in the CHAR_ARRAY OUT parameter.getArray() retrieves the collection returned by the function. The first two rows consisting of the concatenated employee IDs and names are displayed:
8 Advanced JDBC Connector Functionality : 8.6 Using Object Types and Collections with Java : 8.6.2 Using a Collection
![]() |
![]() |
![]() |