Hi,
just my 2 cents. How about something like this:
while(($line = eval { $sth->fetchrow_arrayref() }) || $@)
{
next unless $line;
...
}
Vadim.
On Thu, 15 Jul 2004, Edward Peschko wrote:
> hey all,
>
> How do you make errors that are otherwise fatal, warnings?
>
> I'm getting an oracle error which I think is a oracle bug (01801), and only
> effects one row of an otherwise large, large table. I'd like to be able to trap
> the error, skip the row, and load the rest of the table.. eval doesn't work, because
>
> eval
> {
> while ($line = $sth->fetchrow_arrayref())
> {
> ...
> }
> }
>
> kills the whole loop, whereas I want to be able to terminate *one* row in the loop.
> (and it seems to be overkill to wrap each call to fetchrow_arrayref() in an eval,
> although I suppose I could do that..)
>
>
> Thanks much,
>
> Ed
>
