Re: Cursors : parameters vs bind variables

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Wed, 4 Dec 2002 00:22:48 -0000
Message-ID: <y0_w9.5685$Do4.111373@newsfep1-gui.server.ntli.net>

go to http://asktom.oracle.com and search for bind variables

they are MUCH better for performance as the query only has to be parsed once plus you wont be filling up your library cache (i think) with loads of queries which are essentially the same
should be used if you have a choice really

"Le JeanMimi" <scjm_at_noos.fr> wrote in message news:c7be5048.0211021441.412feede_at_posting.google.com...
> I'm reading the Oracle PL/SQL User's Guide and i've got a small
> question with cursors.
>
> What are the differences between :
> - cursors using bind variables
> - passing cursor parameters
> (- or even cursors referencing variables in the current pl/sql scope)
>
> in terms of parsing, performance, concepts ...
>
> They seems very similar to me but i feel that bind variables are more
> powerful.
> Can I have some explanations ? (sorry if it's a dumb question)
>
> TIA
>
> Jean-Michel
Received on Tue Dec 03 2002 - 18:22:48 CST