Home » Developer & Programmer » Forms » ORA-00971: missing SET keyword
ORA-00971: missing SET keyword [message #79816] Tue, 16 July 2002 08:03 Go to next message
Denise Wagner
Messages: 7
Registered: July 2002
Junior Member
Hi everyone,

I am creating a form in which I have a block made up of data from 2 tables. When I try to commit the user's changes (which apply to one of the 2 tables only), I get an error "ORA-00971: missing SET keyword". This would seem simple, however, the SQL statement in error is:

UPDATE SPRIDEN,NWRINCR SET NWRINCR_FUND_PERCENT=:1,NWRINCR_ANN_SALARY_06=:2,NWRINCR_INCREASE_PERCENT=:3,NWRINCR_INCREASE_07=:4,NWRINCR_ANN_SALARY_09=:5 WHERE SPRIDEN_PIDM=:6 AND NWRINCR_POSN=:7 AND NWRINCR_FUND_CODE=:8

You will notice the SET keyword is not missing. What am I missing that this won't work?

Thanks for any assistance,
Denise
Re: ORA-00971: missing SET keyword [message #79821 is a reply to message #79816] Tue, 16 July 2002 20:42 Go to previous message
Subhash
Messages: 105
Registered: October 2001
Senior Member
In the Block property ,set the 'DML Data Target Name' as the name of the Table to be updated. Now set 'Query Only property' to 'Yes' for the Items of the other table.
Previous Topic: Locking of rows from forms-6i
Next Topic: executing programs from Forms and capture the output
Goto Forum:
  


Current Time: Fri Jul 25 02:18:17 CDT 2014

Total time taken to generate the page: 0.08113 seconds