EXEC pROCEDURE IN TRIGGER
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 29 Jun 2005 01:51:58 -0700 (PDT)
Hi,
Would it be possible to execute my procedure in
trigger ?
I have created a test procedure name : testproc
I can execute this testproc in sql/plus by issue this
command
sql:> exec testproc('abc'); -- no problem
I thought of calling this from trigger body, is that
possible ?
example in trigger abc_trg
Begin
exec testproc('abc');
end;
I tried ... got error. Wonder if this is possible.
Thank in Advanced
Cheers
JK
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
