The methods described in Using Arrays to Input Parameter Values and Retrieving a Result Set into an Array use compound SQL to optimize the network flow.
Use these methods as much as possible.