title: How to use External Procedures in Triggers on Oracle 11g
body: <p>I want to fire a trigger whenever an insert command is fired..</p>
  
  <p>The trigger will access a pl/sql file which can change anytime.. </p>
  
  <p>So the query is, if we design the trigger, how can we make sure this dynamic thing happens.. As during the stored procedure, it is not working..</p>
  
  <p>I think - it should work for</p>
  
  <pre><code>1) External Procedures 
  2) Execute Statement
  </code></pre>
  
  <p>Please correct me, if I am wrong.. I was working on External Procedures but i am not able to find the way to execute the external procedure from here on..</p>
  
  <pre><code>SQL&gt; CREATE OR REPLACE FUNCTION Plstojavafac_func (N NUMBER) RETURN NUMBER AS
    2  LANGUAGE JAVA
    3  NAME 'Factorial.J_calcFactorial(int) return int';
    4  /
  </code></pre>
  
  <p>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@</p>
  
  <pre><code>SQL&gt; CREATE OR REPLACE TRIGGER student_after_insert
    2  AFTER INSERT
    3  ON student
    4  FOR EACH ROW
  </code></pre>
  
  <p>How to call the procedure from heree... And does my interpretations are right,, plz suggest..</p>
  
  <p>Thanks.</p>