OraFAQ Forum: Forms » ora-40737 in go

Home » Developer & Programmer » Forms » ora-40737 in go

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

ora-40737 in go [message #654687]

Wed, 10 August 2016 06:10

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

sir
i have to block
1. employ
2. dependent
-----------
see my code in master block employ
POST_INSERT event

to_item(dependent.dep_id);

but this code give me error frm-40737 illegal restricted procedure go_item
please give me idea how work this code

Report message to a moderator

Re: ora-40737 in go [message #654697 is a reply to message #654687]

Wed, 10 August 2016 08:22

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can't use go_item (and certainly not to_item as you wrote) in post-insert.
We can't suggest an alternative without knowing why you are trying to use it.

Report message to a moderator

Re: ora-40737 in go [message #654736 is a reply to message #654697]

Thu, 11 August 2016 07:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally, if you open Forms Online Help system, search for "restricted procedures" and actually read what's written in there, you'll much better understand what they are and why you can't use them in certain triggers.

Report message to a moderator

Previous Topic:	where i past query for move deptname to textbox
Next Topic:	webutil

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:04:04 CDT 2025