Update impossible [message #557420] |
Tue, 12 June 2012 12:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/125cdc238479d5a1c21d9f9798a84215?s=64&d=mm&r=g) |
vantran
Messages: 11 Registered: April 2012 Location: CANADA, MONTREAL
|
Junior Member |
|
|
Hi,
Please, could you tell me why I got the error Oracle E40509 (Update impossible)
when I save my record table ? Thank you.
SELECT NO_SEQ_ROLE
INTO NO_SEQ
FROM ROLE
WHERE MEMBRE1_ROLE = :BLO_ROLE.CONCIL_ROLE AND
CODE_SECTION_ROLE = :BLO_ROLE.CODE_SECTION_ROLE AND
no_formation_role = :BLO_ROLE.NO_FORMATION_ROLE AND
TO_CHAR(DATE_DU_ROLE,'RRRR') = :BLO_ROLE.TXT_ANNEE;
UPDATE ROLE
SET MEMBRE2_ROLE = :BLO_ROLE.CONCIL_ROLE_S
WHERE MEMBRE1_ROLE = :BLO_ROLE.CONCIL_ROLE AND
NO_SEQ_ROLE = NO_SEQ;
|
|
|
Re: Update impossible [message #557421 is a reply to message #557420] |
Tue, 12 June 2012 12:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Well, "update impossible" is not an Oracle error message I ever encountered, and ORA-40509 does not exist in my version of Oracle either (10.2.0.1.0).
Are you sure this is Oracle? Or is it some application that just uses Oracle as a backend database?
|
|
|
|
|
|
Re: Update impossible [message #557444 is a reply to message #557440] |
Tue, 12 June 2012 14:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Littefoot said you should go to the form run-time help menu and press display error when you get that error.
What you've posted is from form builder help, not form run-time help.
|
|
|
|