Home » Developer & Programmer » Forms » Update impossible (Form 11g orcale form)
Update impossible [message #557420] Tue, 12 June 2012 12:01 Go to next message
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;

Report message to a moderator

Re: Update impossible [message #557421 is a reply to message #557420] Tue, 12 June 2012 12:30 Go to previous messageGo to next message
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?

Report message to a moderator

Re: Update impossible [message #557424 is a reply to message #557421] Tue, 12 June 2012 12:42 Go to previous messageGo to next message
vantran
Messages: 11
Registered: April 2012
Location: CANADA, MONTREAL
Junior Member
Hi,

I'm just checking the message error like as: E40509-Error Oracle: update impossible. (I translate from French to English).

I'm programing Forms 10g, database Oracle.

Thanks.

Report message to a moderator

Re: Update impossible [message #557429 is a reply to message #557424] Tue, 12 June 2012 13:27 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Run the form again. When the error appears, go to Form's Help menu and choose "Display error". It should tell you the reason. If you don't understand it, post its contents over here.

Report message to a moderator

Re: Update impossible [message #557440 is a reply to message #557429] Tue, 12 June 2012 14:01 Go to previous messageGo to next message
vantran
Messages: 11
Registered: April 2012
Location: CANADA, MONTREAL
Junior Member
FRM-40509: ORACLE error: unable to UPDATE record.


Cause: A fatal error occurred while trying to update a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

Action: Contact your DBA.

Level: 99

Trigger: ON-ERROR

Report message to a moderator

Re: Update impossible [message #557444 is a reply to message #557440] Tue, 12 June 2012 14:08 Go to previous messageGo to next message
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.

Report message to a moderator

Re: Update impossible [message #557445 is a reply to message #557440] Tue, 12 June 2012 14:17 Go to previous message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what I meant:

/forum/fa/10241/0/

Report message to a moderator

Previous Topic: How can we rollback back once we commited
Next Topic: Hours and Minutes Total
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 21:31:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.