Home » Developer & Programmer » Forms » FRM 40737 - Illegal restricted procedure
FRM 40737 - Illegal restricted procedure [message #80106] Mon, 12 August 2002 07:42 Go to next message
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 Go to previous message
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;
Previous Topic: incorporating Barcode Reader in Developer forms
Next Topic: No response from OTN site for this - why not try this one
Goto Forum:
  


Current Time: Fri Sep 24 06:39:41 CDT 2021