Oracle Error Unable To Update Record
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
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 https://community.oracle.com/thread/1050142 FRM-40509 Oracle error Unable to Update record. anybody help me ? 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 http://www.orafaq.com/forum/t/69362/ and function_id=:function_right.function_id; COMMIT; ****************************************************** use commit_form to save changes. Sandy Report message to a moderator 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 sandeepk
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand https://www.experts-exchange.com/questions/20947375/FRM-40509-Oracle-unable-to-update-record.html Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > FRM-40509 Oracle unable to update record Want to Advertise Here? Solved FRM-40509 https://groups.google.com/d/topic/comp.databases.oracle.tools/KjQ4u9baO6U Oracle unable to update record Posted on 2004-04-07 Oracle Database 1 Verified Solution 8 Comments 9,980 Views Last Modified: 2011-08-18 I have a view from a single table created by the user trying to perform the oracle error update. I am unable to update though. When I click Help about error I get the message ORA 01733: Virtual column not allowed here. Help! 0 Question by:uTab Facebook Twitter LinkedIn Google LVL 47 Active 1 day ago Best Solution byschwertner If you want to INSERT, UPDATE, DELETE records based on views you have two ways. The FIRST one is to provide DB triggers of type "Instead of" to do these actions. Example: oracle error unable create or replace view CAND_PGRS_VIEW Go to Solution 8 Comments LVL 2 Overall: Level 2 Oracle Database 2 Message Expert Comment by:n4nazim2004-04-07 Hi, Pl post the view SQL and the code which gives u this error.. Rgds, Nazim M 0 LVL 22 Overall: Level 22 Oracle Database 19 Message Active 2 days ago Expert Comment by:Henka2004-04-07 ORA-01733 virtual column not allowed here Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view. Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view. It seems that you want to manipulate "not a single column" in your view. So you can try to make properties of this column in your block: insert_allowed=no update_allowed=no delete_allowed=no I hope this will help you. 0 LVL 5 Overall: Level 5 Message Expert Comment by:KarcOrigin2004-04-07 Hi, Just check if your view or the object is readonly. The error message could be misleading. Here it shows as if the error was because the alias of the column is used. Just check it. 0 LVL 5 Overall: Level 5 Message Expert Comment by:KarcOrigin2004-04-07 Hi, If your view is not read only then just check if you are trying to update the columns that are based on the arithme
GoogleВойтиСкрытые поляПоиск групп или сообщений