illegal restricted procedure error. [message #520907] |
Thu, 25 August 2011 06:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9fc2c55773e60a8cef395fa8cb47a31f?s=64&d=mm&r=g) |
goparaju
Messages: 54 Registered: June 2011
|
Member |
|
|
Hi Experts,
I have data block, after inserting records, in post insert i am using 'GO_ITEM' built_in as i have to move cursor to particular item in anohter block.
It's giving 'Illegal Restricted procedure' error. Could somebody help me how to move cursor to particular item of another block after inserting record.
Kindly help.
|
|
|
|
|
|
|
Re: illegal restricted procedure error. [message #521472 is a reply to message #521044] |
Tue, 30 August 2011 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You'll have to do that in a trigger that accepts restricted procedures. For example, create your own "Save" button. Write a WHEN-BUTTON-PRESSED trigger; in there, insert a header record first, then GO_ITEM, then loop through the detail block.
On the other hand, your life would be much simpler if you created those blocks as data blocks (based on tables). Why didn't you do that? If you did, a simple COMMIT would solve all your problems.
|
|
|