Current Position:Home > ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WHEN-VALIDAT

ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WHEN-VALIDAT

Update:11-30Source: network consolidation
Advertisement
Dear All Expersts,
In a form we want to update another table ON-VALIDATE-ITEM Or POST-UPDATE or POST-INSERT Event
Could you please guide us can we do this without any error message i.e
ON-VALIDATE-ITEM
40737: Illegal restricted procedure COMMIT in WHEN-VALIDATE-ITEM trigger.
Please guide.
Thanks & Best Regards
Eidy

The Best Answer

Advertisement
Eidy,
Ok, for one thing, the Post-Update and Post-Insert triggers fire during the Post and Commit Transaction processing so it doesn't make any sense that you would attempt to issue a COMMIT in either of these triggers because it is already in the process of COMMITING.
I think it would be best if you explain what it is you what to accomplish rather than how you are trying to accomplish the task. Then we will know why you are attempting a COMMIT (Restricted Built-in) in a When-Validate-Item trigger (will allows DML, Select, and Unrestricted calls).
If you intent is to update/insert a record into a seperate table (say for auditing purposes) when a user changes a value in a different block (table) item - perhaps an After Update/Insert trigger on the database table would be a better option. This makes the secondary update/insert automatic and you don't have to code it in all of your forms.
Again, like I said - if you tell us what you are trying to do, we can tell you if you are going about it the right way.
@DanielB - All I can says is HUH?
Craig...
  • ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WHEN-VALIDAT Update:11-30

    Dear All Expersts, In a form we want to update another table ON-VALIDATE-ITEM Or POST-UPDATE or POST-INSERT Event Could you please guide us can we do this without any error message i.e ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WH

  • FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger Update:11-30

    Hi All, I tried to execute an insert statement in a POST-TEXT-ITEM trigger and use commit to save data in the db but this error appeared: FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger How to solve it? OR how to save every t

  • FRM-40737:illegal restricted procedure COMMIT in WHEN-VALID_RECORD trigger Update:11-30

    Hello, I added the following code in Custom.pll, Event procedure. When Internet Expenses responsibility is added to a user on the User form in System Administrator repsonsibility, his default account will be populated from costing. I received error,

  • FRM-40735: illegal restricted procedure COMMIT in POST-CHANGE trigger Update:11-30

    I am using forms6i. I have three text fields FL1 ,*FL2* , FL3 in a form. Cursor passes from FL1 to FL2 and FL2 to FL3. I want when cursor transfers from FL1 to FL2 the form should be saved(commit). On FL1 i put COMMIT; in post-change. But when I pres

  • FRM 40737: Illegal Restricted Procedure   in !!! HELPPP Update:11-30

    Hi: I have to use a program unit in Pre-Insert/ Pre-update triggers. That program unit calls some restricted built ins. Hence whenever I am using that program unit in validation triggers its giving FRM 40737 - Illegal restricted procedure FIRST_RECOR

  • FRM-40737: Illegal restricted procedure (Ver 9.0.2.7.0) Update:11-30

    My form updates State code data. I get state from the from, perform query and populate the form myself. After the last field is entered I perform the update query, then a commit. This error is on the commit. Help!Jose, Some built-ins cannot be called

  • FRM:40737 Illegal restricted procedure ERASE in WHEN VALDATE-RECORD trigger Update:11-30

    Hi I am getting this error when I enter the Sales Order and try to save it sometimes. Can anyone please tell me how I can avoid this and what is the reason for this error? Sachinok, then it is an apps problem. can you copy the question in the EBS-For

  • Illegal restricted procedure Synchronize - error in webforms Update:11-30

    Hi All, When trying to open a webform (Oracle 9i/10g) with a field having synchronize built-in in the when-validate-item trigger, I am getting an error "Frm-40737:Illegal restricted procedure SYNCHRONIZE in WHEN-VALIDATE-ITEM trigger". Is Synchr

  • FRM40737: Illegal restricted procedure SET_WINDOW_PROPERTY in... Update:11-30

    FRM40737: Illegal restricted procedure SET_WINDOW_PROPERTY in WHEN_VALIDATE_ITEM trigger the code inside my when-validate is as follows: declare      button number; begin if :gse_packing_list_edit.carton_ref is null then      button :=show_alert('car

  • Illegal restricted procedure error Update:11-30

    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 cu