Home » SQL & PL/SQL » SQL & PL/SQL » Using Triggers to call procedures
Using Triggers to call procedures [message #36547] Tue, 04 December 2001 05:43 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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).

----------------------------------------------------------------------
Previous Topic: Re: Problems with parmeter in procedures
Next Topic: Format conversion +999,999,999.99
Goto Forum:
  


Current Time: Tue Mar 31 11:50:16 CDT 2020