On Sep 11, 7:12 pm, [EMAIL PROTECTED] (Jeevs) wrote:
> I understand a $stmt->execute($sql) will return me the recordset and I
> can fetch the records using fetchrow_hashref and other methods....
>
> Howeveer I have a scenario where I get multiple datasets, ( Reason :
> My Stored Procedure calls other Stored PRocedures internally.) with
> individual record sets.
>
> How can I traverse this record sets of different datasets.
>
> Output of Query is generally
> CNT NAME
> 1 xyz
> 2 zyx
>
> In my case I want to retrieve datasets like
>
> CNT Name
> 1 xyz
> 2 zyx
>
> CNT ADDRESS
> 1 zyz
> 2 asda
fetch returns me all the results but it just doesn't know when to stop
i.e
while (my @arr = $sth->fetch){
print Dumper @arr;
}
it goes in infinite loop
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
