We have a lot of similar queries (see attached) that return a non-unique identifier and two varrays. One varray is a timestamp array and the other is a float value array. See attached SQL. We are currently returning on the order of 1600 rows. We would like to change the settings in DBD::Oracle 1.23 (or possibly upgrade), possibly change the queries to use table functions (how?). Our DBA suggested using "set arraysize" how do you do that from DBD::Oracle? We have VARRAY(200) for our varrays.
Thanks! John Carlson
cryo.sql
Description: cryo.sql