OraFAQ Forum: Forms » FRM-40737 --- Occured for a form

Home » Developer & Programmer » Forms » FRM-40737 --- Occured for a form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40737 --- Occured for a form [message #161808]

Tue, 07 March 2006 05:20

live2learn
Messages: 34
Registered: February 2006

Member

Hi All,

" FRM-40737 Illegal restricted procedure message"error is being occured on the trigger ON-ERROR.
I know that this trigger will be fired when an error occurs and certain reasons for this errors are passing an unexpected value for a parameter , a restricted built-in procedure is called from pre-,post-,on-...etc., triggers.

But can anybody provide me with an answer for the reasons of the error apart from the above mentioned ones...

Thanks & Regards,
Saritha

Report message to a moderator

Re: FRM-40737 --- Occured for a form [message #161885 is a reply to message #161808]

Tue, 07 March 2006 13:25

M0nst3r
Messages: 38
Registered: February 2006
Location: Wherever the Money Is

Member

As the error states, you're calling a restricted procedure from your On-Error trigger. Remove any navigation commands, such as GO_ITEM() or GO_BLOCK(), from your On-Error trigger code.

Report message to a moderator

Re: FRM-40737 --- Occured for a form [message #161936 is a reply to message #161885]

Tue, 07 March 2006 23:38

live2learn
Messages: 34
Registered: February 2006

Member

Hi,
Thx for ur reply. But i already specified in my mail that ..it is not because of what u said ..

The reason for this is some of the library files are missing on my system.

Done using another system and thank you once again for your response.

Thanks & Regards,
Saritha

Report message to a moderator

Re: FRM-40737 --- Occured for a form [message #668612 is a reply to message #161936]

Tue, 06 March 2018 22:51

faizan.zahid
Messages: 1
Registered: March 2018

Junior Member

can u tell me which libraries we should add?? i m facing the same problem?

Report message to a moderator

Re: FRM-40737 --- Occured for a form [message #668614 is a reply to message #668612]

Wed, 07 March 2018 01:48

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

You have posted your question as a reply to a topic that is twelve years old. You may get better response if you create a new topic. Be sure to give all the information you can, and use [code] tags if appropriate.

Report message to a moderator

Previous Topic:	folder name in oracle forms
Next Topic:	Import excel file in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:38:49 CST 2025