Oracle Forms Error 40509
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 6 Replies Latest reply on Mar 25, 2010 7:39 AM by user620717 FRM - 40509 : ORACLE error: unable to UPDATE record user620717 Mar 24, 2010 9:08 AM Hi, I have a form named as request and two user A & B, user A is having a insert, update, delete and select privileges and user B is having select as well as update in two column only... what ever user A will create, User B has to execute it and modify the two columns...... The problem is while user B is trying to update that two column, user B is getting an error message *"FRM - 40509 : ORACLE error: unable to UPDATE record"* so, pls suggest me what i have to do.... Grant statement is as follows: Grant select,insert,update,delete on request to a; grant select on request to B; grant update(status1) to B; grant update(status2) to B; Thanks in advance... I have the same question Show 0 Likes(0) 11826Views Tags: none (add) This content has been marked as final. Show 6 replies 1. Re: FRM - 40509 : ORACLE error: unable to UPDATE record Ammad Ahmed Mar 24, 2010 9:37 AM (in response to user620717) This error is not very clear. on your form when error is coming press SHiFT+F1 then it will show you the exact error post that error here. Then you can find the better solution. -Ammad Like Show 0 Likes(0) Actions 2. Re: FRM - 40509 : ORACLE error: unable to UPDATE record user620717 Mar 24, 2010 10:48 AM (in response to Ammad Ahmed) Hi Ammad, Yeah u r absolutely right, its a generic error, my exact error is insufficient priveleges.....Pls suggest me is it necessary update priveleges should given on table even what ever i want to update i given the update privelges on particular column...... thanks Sajid Like Show 0 Likes(0) Actions 3. Re: FRM - 40509 : ORACLE error: unable to UPDATE record Ammad Ahmed Mar 24, 2010 11:02 AM (in response to user620717) make sure that owner of the table has given the update privileges on that column(s) to the user B. The exact statement of giving privileges is... grant update(column1, column2...) on table_name to user_name; This command you have to exe
with FRM-40509(Unable to Update record) mistake [message #192586] Tue, 12 September 2006 22:46 nhom9a Messages: 51Registered: July 2005 Location: VN Member Hi all. I have one table with name Function_right(function_id,function_name,description,user_id,visible_invisible) I onle want to update "visible_invisible" column. I have created form layout with block function_right, I have chosen update changed column only is yes for block and all column except "visible_invisible" with update allowed is No. I have a button with code: update function_right set visible_invisible=:function_right.visible_invisible where user_id=:users.user_id and function_id=:function_right.function_id; COMMIT; When I press this button I get a mistake FRM-40509 Oracle error Unable to Update record. anybody help me ? https://community.oracle.com/thread/1050142 thanks. Report message to a moderator Re: Help me with FRM-40509(Unable to Update record) mistake [message #192592 is a reply to message #192586] Tue, 12 September 2006 23:14 sandeepk7 Messages: 137Registered: September 2006 Senior Member You do not need to write ***************************************************** update function_right set visible_invisible=:function_right.visible_invisible where user_id=:users.user_id and function_id=:function_right.function_id; COMMIT; ****************************************************** use commit_form to save changes. Sandy Report message to a moderator http://www.orafaq.com/forum/t/69362/ Re: Help me with FRM-40509(Unable to Update record) mistake [message #192594 is a reply to message #192586] Tue, 12 September 2006 23:24 nhom9a Messages: 51Registered: July 2005 Location: VN Member Thanks Sandy. I've already tried to use commit_form. But I also received this error. Report message to a moderator Re: Help me with FRM-40509(Unable to Update record) mistake [message #192596 is a reply to message #192594] Tue, 12 September 2006 23:27 sandeepk7 Messages: 137Registered: September 2006 Senior Member is there any update trigger on table? Report message to a moderator Re: Help me with FRM-40509(Unable to Update record) mistake [message #192600 is a reply to message #192586] Tue, 12 September 2006 23:36 nhom9a Messages: 51Registered: July 2005 Location: VN Member No. I don't have any trigger on this table. Report message to a moderator Re: Help me with FRM-40509(Unable to Update record) mistake [message #192611 is a reply to message #192586] Wed, 13 September 2006 00:21 sandeepk7 Messages: 137Registered: September 2006 Senior Member ok, when getting "FRM-40509 Oracle error Unable to Update record." Press Shift+F1 to see what exactly worng with this query. Send this Error message. Sandy Re
van GoogleInloggenVerborgen veldenZoeken naar groepen of berichten