Example: create or replace view CAND_PGRS_VIEW Go to Solution 2 2 +3 6 Participants schwertner(2 comments) LVL 47 Oracle Database47 KarcOrigin(2 comments) LVL 5 Helena Marková LVL 22 Oracle Database19 baonguyen1 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 LVL 8 Overall: Level 8 Oracle Database 8 Message Expert Comment by:baonguyen12004-04-08 Comment Utility Permalink(# a10781413) This error can happen if when you try to update or insert on a Forms I am unable to update though.
The FIRST one is to provide DB triggers of type "Instead of" to do these actions. anybody help me ? Results 1 to 6 of 6 Thread: FRM-40509 :Oracle error :unable to update record Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch
thanks once again Reply With Quote 04-17-2003,06:55 AM #4 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 No problem, 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. Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication any way i will try out your suggestion.
Good luck! 0 Message Author Comment by:uTab2004-04-08 Comment Utility Permalink(# a10786020) You all are my heros. Connect with top rated Experts 16 Experts available now in Live! This error occurs because you have created a virtual column in your view. http://www.orafaq.com/forum/t/69362/ I altered one of the table to suit my requirement and have compiled the form .
Oracle Database Advertise Here 684 members asked questions and received personalized solutions in the past 7 days. 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. In menu Help --> Disply Error Reply With Quote Quick Navigation Oracle Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database The error message could be misleading.
Join & Write a Comment Already a member? 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 Reply With Quote 04-17-2003,06:51 AM #3 jclc View Profile View Forum Posts Junior Member Join Date Apr 2003 Location Malaysia Posts 3 Hi Jovery Thank you ! Select a Product...
Get 1:1 Help Now Advertise Here Enjoyed your answer? http://vbview.net/oracle-error/oracle-error-when.php This is the expected product behaviour. To start viewing messages, select the forum that you want to visit from the selection below. i cant see it Reply With Quote 08-01-2007,03:44 AM #6 bhattnirav View Profile View Forum Posts Member Join Date Apr 2001 Location Vadodara, India Posts 249 RUN your FMX.
Donald K. Example: create or replace view CAND_PGRS_VIEW as select cp.id, cp.to_employee, cp.progress_type, cp.planned_on_date, cp.held_on_date, cp.result, cp.remark, cpt.name, cpt.place, cpt.in_use from CANDIDATE_PROGRESS cp, CANDIDATE_PROGRESS_TYPE cpt where cp.progress_type = cpt.id; CREATE OR REPLACE TRIGGER The corresponding Datapump Import utility is also discussed and demonstrated. http://vbview.net/oracle-error/oracle-error-help.php Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
Search BC Oracle Sites HomeE-mail Us Oracle Articles New Oracle Articles Oracle TrainingOracle Tips Oracle ForumClass Catalog Remote DBAOracle TuningEmergency 911RAC SupportApps SupportAnalysisDesignImplementationOracle SupportSQL The FIRST one is to provide DB triggers of type "Instead of" to do these actions. Action: Contact your DBA.
But when i enter any data it shows an error "frm-40509 --Unable to update record" and does not gets saved. I gave the points to schwertner because he answer was excellent and helped me get my right direction working. PRTG is easy to set up & use. weblink Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of
Errata? Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson BlogFRM-40509: unable to UPDATE record Tips Oracle Database Tips Thanks Reply With Quote 04-17-2003,05:42 AM #2 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 FRM-40509 is a generic