Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL text within TRIGGERs

PL/SQL text within TRIGGERs

From: <J.Velikanovs_at_alise.lv>
Date: Tue, 22 Jun 2004 12:25:32 +0300
Message-ID: <OFDC67D6B9.6F00AB6A-ONC2256EBB.00337D8E-C2256EBB.00346D6D@alise.lv>


Hi gurus!
At the beginning of my career ~5-6 years ago some one, told me that write PL/SQL text within TRIGGER body is not good idea, because trigger text compiling by Oracle at each trigger call. And it is better idea, to call from trigger just procedure there we implement all the code. At the moment I don’t remember who told me about this issue, I even don’t know was it at Oracle course or at other event time.

Is this recommendation is myth or it still true for Oracle environment. Can anybody comment on it?

Thank you in advance,
Jurijs



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 Tue Jun 22 2004 - 04:29:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US