EXEC pROCEDURE IN TRIGGER

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 29 Jun 2005 01:51:58 -0700 (PDT)
Message-ID: <20050629085158.89600.qmail@web52904.mail.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 29 2005 - 04:58:31 CDT