| FRM 40737 - Illegal restricted procedure [message #80106] |
Mon, 12 August 2002 07:42  |
Srini
Messages: 28
Registered: November 2000
|
Junior Member |
|
|
Hi:
I have to use a program unit in Pre-Insert/ Pre-update triggers. That program unit calls some restricted built ins. Hence whenever I am using that program unit in validation triggers its giving FRM 40737 - Illegal restricted procedure <REST BUILT IN> in <VALID'N TRIGGER>.
Can somebody help.
came to know that using timer can help. can somebody explain how to use timers/ alternative???
thanks.
|
|
|
|
| Re: FRM 40737 - Illegal restricted procedure [message #80140 is a reply to message #80106] |
Wed, 14 August 2002 20:17  |
d
Messages: 18
Registered: October 2000
|
Junior Member |
|
|
Basically, the idea is to create a timer that expires immediately, so the code in the timer executes immediately. You declare your timer variable:
temp_timer TIMER;
Next, you create your timer object wherever you want
to do your restricted procedure. In your case, your validation triggers.
temp_timer := Create_Timer('MY_TIMER', 1, NO_REPEAT);
You name it something unique, and set it to expire, and not repeat. Next, in your WHEN-TIMER-EXPIRED trigger, you check for the expiration of this timer.
So, in your WHEN-TIMER-EXPIRED trigger, you would have something like this:
IF Get_Application_Property(TIMER_NAME) = 'MY_TIMER' THEN
-- illegal restriced code
END IF;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
