Using Triggers to call procedures [message #36547] |
Tue, 04 December 2001 05:43 |
Mitus
Messages: 1 Registered: December 2001
|
Junior Member |
|
|
I want to use a trigger to call a Procedure that I have built in the "SYS" Schema. The trigger is found in another schema. I do not know if that is at all possible. I have been having compilation problems. Can someone help me or has anyone tried?
Mitus...
----------------------------------------------------------------------
|
|
|
Re: Using Triggers to call procedures [message #36550 is a reply to message #36547] |
Tue, 04 December 2001 06:22 |
tinel
Messages: 42 Registered: November 2001
|
Member |
|
|
Hi
you can call a procedure built in another schema only if you have role granted, to do this you connect as sys and give role to user in wich schema you want to use the stored procedure
----------------------------------------------------------------------
|
|
|
Re: Using Triggers to call procedures [message #36558 is a reply to message #36547] |
Tue, 04 December 2001 11:35 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
connect as sys
grant privileges to other schema where trigger created.
grant execute on proc_name to other_schema.
now you can reference procedure name in other_schema by prefixing SYS (means sys.proc_name).
----------------------------------------------------------------------
|
|
|