Re: When to use bulk binds?

Jusung Yang wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EB1CA44.30E2F660_at_exxesolutions.com>...
> > Jusung Yang wrote:
> >
> > > Would be nice if you can post your codes, easier to understand your
> > > situation that way. You use bulk bind to reduce the context switch
> > > overhead between SQL and PL/SQL.
> > >
> > > <snipped>
> >
> > Your statement brings an interesting question to mind. With Oracle 9i the SQL and PL/SQL engines were
> > combined.
> >
> > Did this elminate the context switching?
> >
> > Thanks.
>
> They now share the same "SQL parser", Daniel. This according to Tom
> Kyte. So there will still be a switch between SQL and PL/SQL.
>
> - Jusung Yang

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)