Oracle Forms Error Code 40508
Contents |
Show: Today's Messages :: Show Polls :: Message Navigator E-mail to friend FRM-40508: Oracle error: unable to INSERT record (Simple/Weird error) [message #568820] Tue, 16 October 2012 21:35 reppihsrow Messages: 22Registered: October 2012 Junior frm-40508 solution Member I have this error. To put it simply I have two blocks.
Frm-40508 Ora-01403
Block1 contains two drop down list with PL/SQL statements for queries. Block2 contains tabular form created from block wizard
Ora 040508
(I tried already in manual) that will catch the result in Block1 queries. Now I have a button with a trigger when-button-pressed that contains BEGIN INSERT INTO dummy1 VALUES ('hello',1,2,3); COMMIT; END; My
Display Error Key Oracle Forms
goal is to add into dummy1 values from :block2.item_name1, :block2.item_name2, :block2.item_name3 but to put it simply I tried these values but I received the same error. When I run it and first things first click the button, the values will be added into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error. frm-40408 database commit failure Please help me. I urgently need this. Thanks. Report message to a moderator Re: FRM-40508: Oracle error: unable to INSERT record (Simple/Weird error) [message #568874 is a reply to message #568820] Wed, 17 October 2012 06:14 cookiemonster Messages: 12341Registered: September 2008 Location: Rainy Manchester Senior Member The error is not due to that insert statement. The commit causes oracles default insert process to run. This will try to insert records from the datablocks into the DB. That's erroring. Use the display error option on the run time help menu to see why it's erroring. I doubt you need the insert statement at all. Report message to a moderator Re: FRM-40508: Oracle error: unable to INSERT record (Simple/Weird error) [message #569613 is a reply to message #568874] Tue, 30 October 2012 05:31 reppihsrow Messages: 22Registered: October 2012 Junior Member Thanks for the reply cookiemonster. But I need the insert statement. This was solved by going to property palette and changing the properties of the two blocks in 'database data block' to 'No' and all goes well with me! Report message to a moderator Re: FRM
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 ora 01400 cannot insert null enter a title. You can not post a blank message. Please type 40508 vc your message and try again. More discussions in Forms All PlacesDevelopment ToolsForms 5 Replies Latest reply on Jul 40508 zip code 14, 2016 12:48 AM by 3273964 FRM-40508 : ORACLE error: unable to INSERT record 3273964 Jul 11, 2016 8:56 PM I have a problem when i open_form this error http://www.orafaq.com/forum/t/184531/ is appear FRM-40508 : ORACLE error: unable to INSERT record but when i open the same form from my menu bar it save record normally 925Views Tags: none (add) This content has been marked as final. Show 5 replies 1. Re: FRM-40508 : ORACLE error: unable to INSERT record Manu. Jul 12, 2016 4:10 AM (in response to 3273964) Dear,With https://community.oracle.com/thread/3948948 the error no FRM-40508, we can't suggest anything, post the exact error description, which will get when you press the Shift + F1 for 6i and Shift + Ctrl + e in browser version (By default). Also post the code written in the saving triggers.Manu. Like Show 0 Likes(0) Actions 2. Re: FRM-40508 : ORACLE error: unable to INSERT record Kalpataru Jul 12, 2016 5:08 AM (in response to 3273964) Hi 3273964,Give more details about your error FRM-40508, so that you will get better help.What is your forms version ?How are you calling the open_form ?Go through this.10 Commandments on OTN forum posting.http://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo Like Show 0 Likes(0) Actions 3. Re: FRM-40508 : ORACLE error: unable to INSERT record Kalpataru Jul 12, 2016 2:22 PM (in response to 3273964) Hi 3273964,If your block is based on database block, then check your item's property Insert Allowed, Update Allowed and Delete Allowed must be set yo Yeswhile inserting records into the block.Hope it solves your issue. Like Show 0 Likes(0) Actions 4. Re: FRM-40508 : ORACLE error: unable to INSERT
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/frm40508oracle-error-unable-to-insert-record-3733432 PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus oracle forms Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 blrvenkat COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question Informatica The Informatica group is your premier resource for objective technical discussion oracle forms error and peer-to-peer support on Informatica data integration software. Home | Invite Peers | More Data Warehouse Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. FRM-40508:ORACLE error: unable to INSERT record SandraV asked Sep 2, 2010 | Replies (3) Oracle Names Client Cache for 32-bit Windows: Version 8.0.5.0.0 - Production I get this error when inserting record. Where should I check? Please help Join this group Popular White Paper On This Topic The Death of Traditional Data