OraFAQ Forum: Forms » UPDATE raises FRM-40508: ORACLE error: UNABLE to INSERT record

Home » Developer & Programmer » Forms » UPDATE raises FRM-40508: ORACLE error: UNABLE to INSERT record

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

UPDATE raises FRM-40508: ORACLE error: UNABLE to INSERT record [message #458593]

Mon, 31 May 2010 06:49

ngaari
Messages: 2
Registered: May 2010
Location: saudi arabia

Junior Member

I would like to UPDATE the columns p1 and p2 of my table student (studentid:pk,name,p1,p2,...) for a given studentid.and I have a when-button-pressed trigger with this code:

UPDATE student
SET student.p1=:validation.proj1,
student.p2=:validation.proj2
where UPPER(student.studentid)=UPPER(:validation.studentid);commit_form;

when I run my form with a correct studentid, I got this error:
FRM-40508: ORACLE error: UNABLE to INSERT record

but it is cworking correctly in sqlplus; and I have all priveligies.

thanks for your help.
ngari

[SPLIT and MOVED by LF]

[Updated on: Mon, 31 May 2010 07:41] by Moderator

Report message to a moderator

Re: unable to insert record [message #458596 is a reply to message #458593]

Mon, 31 May 2010 07:25

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Can you tell us what is the relation between your question and the current topic?

Please read OraFAQ Forum Guide.

Regards
Michel

Report message to a moderator

Re: unable to insert record [message #458597 is a reply to message #458596]

Mon, 31 May 2010 07:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When error raises, go to Help form menu and select "Display error". It will reveal the real cause. If you can't figure it out, copy/paste result of the "Display error" here.

Report message to a moderator