Re: Generating Huge Table

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 23 May 2005 06:40:59 -0700
Message-ID: <1116855659.880846.235610@z14g2000cwz.googlegroups.com>

Sybrand Bakker wrote:
> On 23 May 2005 02:06:57 -0700, "Rauf Sarwar" <rs_arwar_at_hotmail.com>
> wrote:
>
> >procedure blah (...,....,....)
> >is
> >begin
> > insert into table ();
> >exception
> > when dup_val_on_index then
> > update table ();
> > when others then
> > raise;
> >end;
> >/
>
> This does work, but trapping an exception everytime is costly.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

How so?

Regards
/Rauf Received on Mon May 23 2005 - 08:40:59 CDT