executing 2 and more statements

[Ing. Branislav Gerzo]

Hello,

I'd like to do something like this:

$sth->prepare(...)
$sth->execute(...)
while (my $hr = $sth->fetchrow_hashref) {
      my $oses = get_os( $hr->{id} );
      ...
}

Function get_os() prepare, execute and return $sth->fetchall_arrayref();
but I'm getting error:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Connection is b
usy with results for another hstmt (SQL-HY000)(DBD: st_execute/SQLExecute err=-1
) at ...

is there some workaround for this, or I have to read all into memory ?