Re: cursor loops
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 30 May 2012 14:09:30 -0400
Message-ID: <CAGurbTPuwqbeiMTOJaTntJUGOik1zgfQ4o0kWAofTgwKZHH3ng_at_mail.gmail.com>
As for implicit/explicit cursors, personally I dont have hard opinions. I use implicit cursors where i can and explicit when i cannot, e.g. when using WITH() clause, sometimes plsql doesn't like implicit cursors that include subquery factoring, maybe it is fixed in 112. Explicit are nice when you use bind variables etc.
Raj
Date: Wed, 30 May 2012 14:09:30 -0400
Message-ID: <CAGurbTPuwqbeiMTOJaTntJUGOik1zgfQ4o0kWAofTgwKZHH3ng_at_mail.gmail.com>
As for implicit/explicit cursors, personally I dont have hard opinions. I use implicit cursors where i can and explicit when i cannot, e.g. when using WITH() clause, sometimes plsql doesn't like implicit cursors that include subquery factoring, maybe it is fixed in 112. Explicit are nice when you use bind variables etc.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 30 2012 - 13:09:30 CDT