OraFAQ Forum: Forms » illegal restricted procedure error.

Home » Developer & Programmer » Forms » illegal restricted procedure error.

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

illegal restricted procedure error. [message #520907]

Thu, 25 August 2011 06:54

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.

Report message to a moderator

Re: illegal restricted procedure error. [message #520915 is a reply to message #520907]

Thu, 25 August 2011 07:28

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

Senior Member

You can't.

Report message to a moderator

Re: illegal restricted procedure error. [message #520918 is a reply to message #520915]

Thu, 25 August 2011 07:47

goparaju
Messages: 54
Registered: June 2011

Member

Thanks for your reply. Any alternative, like writing 'GO_ITEM' in any other trigger or any other solution.

Kindly help.

Report message to a moderator

Re: illegal restricted procedure error. [message #520927 is a reply to message #520918]

Thu, 25 August 2011 08:20

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Are you doing an insert command or simply committing the current record?

Report message to a moderator

Re: illegal restricted procedure error. [message #521044 is a reply to message #520927]

Fri, 26 August 2011 01:14

goparaju
Messages: 54
Registered: June 2011

Member

Hi,

Thanks for your reply. After post insert(header record), i have multi record control block, i have pick those records and insert them against this header record. For this, in 'post insert' trigger i am using GO_ITEM(controlblock.item) --> looping --> INSERT Statement.

Could you help me how to achieve this after inserting header record, i have to insert multiple line records(control block) against this header record.

Kindly help.

Report message to a moderator

Re: illegal restricted procedure error. [message #521472 is a reply to message #521044]

Tue, 30 August 2011 03:49

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.

Report message to a moderator

Previous Topic:	Using copy Excel sheet via OLE2...
Next Topic:	Key next item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 21 14:49:16 CDT 2024