my $plsql=<prepare($plsql); my $sth2; my @row; $sth_ideas->bind_param(":l_project_id",$self->{project_id}); $sth_ideas->bind_param_inout(":l_data",\$sth2,0,{ora_type => ORA_RSET}); $sth_ideas->execute; my $raRow; my $raResults = []; my ($id, $valreal, $valtext, $colorder); $sth2->bind_columns(\($id, $valreal, $valtext, $colorder)); while( $sth2->fetch ) { push @$raResults, [ $id,$valtext ]; } return $raResults;