OraFAQ Forum: Forms » ORA-00971: missing SET keyword

Home » Developer & Programmer » Forms » ORA-00971: missing SET keyword

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

ORA-00971: missing SET keyword [message #79816]

Tue, 16 July 2002 08:03

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

Report message to a moderator

Re: ORA-00971: missing SET keyword [message #79821 is a reply to message #79816]

Tue, 16 July 2002 20:42

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.

Report message to a moderator

Previous Topic:	Locking of rows from forms-6i
Next Topic:	executing programs from Forms and capture the output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 17:04:59 CST 2025