Home » Developer & Programmer » Forms » ora-40737 in go
ora-40737 in go [message #654687] Wed, 10 August 2016 06:10 Go to next message
mfahimaamirgmailcom
Messages: 50
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
Re: ora-40737 in go [message #654697 is a reply to message #654687] Wed, 10 August 2016 08:22 Go to previous messageGo to next message
cookiemonster
Messages: 13895
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.
Re: ora-40737 in go [message #654736 is a reply to message #654697] Thu, 11 August 2016 07:30 Go to previous message
Littlefoot
Messages: 21612
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.
Previous Topic: where i past query for move deptname to textbox
Next Topic: webutil
Goto Forum:
  


Current Time: Fri Oct 23 23:02:22 CDT 2020