How do I write a stored procedure in SQL that will return an Array as an OUT parameter?

Nicholas Whitehead

This is dependent on the JDBC driver and the database interface implementation and is therefore vendor specific.

Joe Sam Shirah adds: In addition, not all databases support the SQL3 types, so you should ensure that your database has this capability as well. However, at that point, there should be little difference, keeping Nicholas' caveat in mind, between returning an Array and any other type. Oracle supports the Array type and you might want to look at their site for examples. See:

Where can I find online documentation for database xyz?