Home » Developer & Programmer » Forms » while updating tables on input in post form getting error -- ORA-01403 and FRM-32086
while updating tables on input in post form getting error -- ORA-01403 and FRM-32086 [message #85431] Fri, 25 June 2004 04:06 Go to next message
domingo
Messages: 54
Registered: June 2004
Member
I want to update some tables on the basis of what I give input in the text box .

I am trying to do  in Post form trigger

But when i am running the form and pressing exit/F4 to exit

I am getting following error and unable to exit.

 ORA-01403  and FRM-32086.

Kindly help me out

Report message to a moderator

Re: while updating tables on input in post form getting error -- ORA-01403 and FRM-32086 [message #85433 is a reply to message #85431] Fri, 25 June 2004 06:37 Go to previous message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
Move your update statement to your KEY-EXIT trigger.

I think you are not allowed to do UPDATEs in a POST-FORM trigger. This is what the docs say

Legal Commands

SELECT statements, unrestricted built-ins

Usage Notes

Use a Post-Form trigger for the following tasks:

o To clean up the form before exiting. For example, use a Post-Form trigger to erase any global variables that the form no longer requires.

o To display a message to the operator upon form exit.

This trigger does not fire when the form is exited abnormally, for example, if validation fails in the form.

Report message to a moderator

Previous Topic: tutorial for oracle developer2000
Next Topic: Running 9i database on 6i forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 02:17:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.