Does anyone have experience with getting more than one record from a stored procedure with Oracle8i? Currently when I want to generate a recordset I use the standard: $sth = $dbh->prepare( $selectstatment ) ; and plugin some sql select. Or for an individual record I might use some stored procedure: $sth = $dbh->prepare( "BEGIN...END;" ) ; The problem I've encountered is when I want to use a stored procedure that returns more than one record. I've tried the example in the documentation for binding the cursor and found it terribly slow. I've looked at the VARRAY and PL/SQL record datatypes, but have had no success. Is there support for these datatypes? Do you have any suggestions? Thanks, Alan
