Oracle Error 40508
Contents |
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 frm-40508 ora-01403 not post a blank message. Please type your message and try again. More
Ora 040508
discussions in Forms All PlacesDevelopment ToolsForms 5 Replies Latest reply on Jul 14, 2016 12:48 AM by 3273964 FRM-40508
Display Error Key Oracle Forms
: ORACLE error: unable to INSERT record 3273964 Jul 11, 2016 8:56 PM I have a problem when i open_form this error is appear FRM-40508 : ORACLE error: unable to INSERT record
Frm-40408 Database Commit Failure
but when i open the same form from my menu bar it save record normally 919Views 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 the error no FRM-40508, we can't suggest anything, post the exact error description, which will ora 01400 cannot insert null 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 record fxmatz Jul 12, 2016 2:29 PM (in response to 3273964) Hi,in ON-ERROR Trigger write first: BEGIN display_error; ..Hope it helps,Friedhold Like Show 0 Likes(0) Actions 5. Re: FRM-40508 : ORAC
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 40508 vc 2012 21:35 reppihsrow Messages: 22Registered: October 2012 Junior Member I have this 40508 zip code error. To put it simply I have two blocks. Block1 contains two drop down list with PL/SQL ora 00001 unique constraint violated statements for queries. Block2 contains tabular form created from block wizard (I tried already in manual) that will catch the result in Block1 queries. Now I have a button https://community.oracle.com/thread/3948948 with a trigger when-button-pressed that contains BEGIN INSERT INTO dummy1 VALUES ('hello',1,2,3); COMMIT; END; My 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 http://www.orafaq.com/forum/t/184531/ into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error. 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
Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems oracle error Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw oracle error 40508 Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service