Re: Implicit vs. Explicit cursors

In our current project we discovered some bugs which we would never have discovered with explicit cursors (too_many_rows exceptions where they were not supposed to occur and which could not be prevented by means of unique constraints...).

Marc

Paul Martin wrote in message <8gjlia$i9s$1_at_bw107zhb.bluewin.ch>...
>Hello
>
>Can anybody tell me how penalizing implicit cursor are on an Oracel 7.3.4.
>Is it worth changing all the implicit cursors to explicit cursors in our
>plsql packages ?
>Should implicit cursors even be used ?
>
>Many thanks
>
>Paul
>
>
>--
>Paul Martin
>pmartin_at_mitsa.ch
>
>
Received on Fri May 26 2000 - 00:00:00 CDT