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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Executing stored procedure within trigger

Re: Executing stored procedure within trigger

From: Mike Burke <mike.burke_at_dial.pipex.com>
Date: 1997/07/23
Message-ID: <33D68268.CB1@dial.pipex.com>#1/1 







Jeff,



In order to execute a stored procedure from within a trigger you must
grant execute privilege DIRECTLY to the user and not via a role.



Also do not use "EXEC procedure" just say "procedure".



If you have any more trouble let me know.



Mike
Received on Wed Jul 23 1997 - 00:00:00 CDT












Original text of this message













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