How do I write a stored procedure in SQL that will return an Array as an OUT parameter?
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: