RE: 'begin end' blocks and pl/sql performance

From: Anthony Molinaro <amolinaro_at_wgen.net>
Date: Fri, 11 Jun 2004 11:18:05 -0400
Message-ID: <D17DB304A9F42B4787B68861F9DAE61C033F26@wgdc02.wgenhq.net>

Ryan,
I don't believe they affect performance at all. What you do get out of it is, "isolation". You can use begin-end blocks to catch exceptions and continue processing.

-----Original Message-----

From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net] Sent: Friday, June 11, 2004 10:57 AM
To: oracle-l_at_freelists.org
Subject: 'begin end' blocks and pl/sql performance

Can extra begin end blocks inside your pl/sql affect performance? If so, how?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Jun 11 2004 - 10:15:00 CDT