| Trigger Mutation problem (jobs Scheduling) [message #41031] |
Tue, 19 November 2002 15:00 |
Sharad Varshney
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
Hi..
I am facing one problem to write one Trigger. I have one procedure (proc1) which enter the data in table1 then table2 and thne table3. The proc1 is very complex and it is a application procedure. I have another procedure (Proc2) which change the table1. Right now Proc1 and Proc2 are running manually and user run them through frontend. Now we want that when we run the proc1 then proc2 should automatically run. For this I created one trigger at Table3 which run the proc3 but I am facing the Mutation problem. As both the procedure are very complex so I don't want to change the procedure. Now what I think that if I create one Temporary table (temp1) and put some perameter and sysdate in the temp table, then is there any way that we can run the proc2 after 5 seconds of that date/time.
Can anyone help to resolve this issue?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
