Oracle Error Codes 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 Member I have this frm-40508 solution error. To put it simply I have two blocks. Block1 contains two drop down
Frm-40508 Ora-01403
list with PL/SQL statements for queries. Block2 contains tabular form created from block wizard (I tried already in manual) that will display error key oracle forms 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 goal is to add into dummy1 values from :block2.item_name1,
Ora 040508
: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. Please help me. I urgently need this. Thanks. Report message to a moderator frm-40408 database commit failure 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-40508: Oracle error: unable to INSERT record (Simple/Weird error) [message #569622 is a reply to message #569613] Tue, 30 October 2012 07:14 cookiemonster Messages: 12341Registered: September 2008 Loca
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
40508 Vc
on and reload this page. Please enter a title. You can
Ora 01400 Cannot Insert Null
not post a blank message. Please type your message and try again. More discussions in Forms 40508 zip code All PlacesDevelopment ToolsForms 5 Replies Latest reply on Jul 14, 2016 12:48 AM by 3273964 FRM-40508 : ORACLE error: unable to INSERT record 3273964 Jul 11, 2016 http://www.orafaq.com/forum/t/184531/ 8:56 PM I have a problem when i open_form this error 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 928Views Tags: none (add) This content has been marked as final. Show 5 replies 1. Re: FRM-40508 : https://community.oracle.com/thread/3948948 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 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,
:this is the cause of the error 3-lis_item (foreign key) / / dynamic list 4-text_item 5-button (insert commit) when I click the button, an error is displayed: FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated http://oracledba.bigresource.com/Forms-FRM-40508-ORACLE-error-unable-to-INSERT-record-cJAR2C3qM.html - parent key not found Note: -the elements of two lists already exist in the parent table!! -I use a block based. -button commit_form(); View 17 Replies Similar Messages: Forms :: Oracle Unable To Update Record - Unique Key Violation Error Forms :: Two Blocks - Unable To INSERT Record Forms :: Insert Record Into Lov Through Oracle Custom Forms? Forms :: ORACLE ERROR Unable To Read List Of Values Forms :: Unable To Save Record Forms oracle error :: Unable To Delete Record? Forms :: Unable To Update Record Forms :: Unable To Save Record In Database Forms :: Unable To Insert Records Forms :: Enable Insert Button For 1 Record Only? Forms :: Unable To Insert Mathematical Symbols? Forms :: INSERT Record - Update Columns Of Table Forms :: Unable To Display A Message When Record Status Is Changed? Forms :: Unable To Insert Checkbox Checked Records? SQL & PL/SQL :: Unable To Insert oracle error codes Georgain Characters Using 6i Forms And Reports? Forms :: How To Insert Records Checked In Multi Record Block Forms :: Insert / Update And Delete Single Record At A Time? Forms :: Display Alert When Click On Insert Record In Tool Bar? SQL & PL/SQL :: Unable To Insert Hindi Language Characters In Oracle 9i Forms :: Insert Unchecked Records After First Insertion In Multi-record Block? Forms :: Insert Record In Table When One Of Item In Database Block Is Filled? Server Administration :: Unable To See / Insert Chinese Characters In Oracle Database Client Tools :: INSERT INTO With GUI - Insert Record Greyed Out? Forms :: ERROR - Record Must Be Entered Or Deleted First Forms :: Error Message - Could Not Reserve Record (2 Tries) Keep Trying Forms :: Pressing On A New Record - Error Frm-41009? Error When Using INSERT INTO In Oracle Insert Into Statement - Getting ORACLE Error? Forms :: FRM-40505 / Unable To Perform Query Error ADVERTISEMENT Forms :: Oracle Unable To Update Record - Unique Key Violation Error May 10, 2011 I have the search screen in my form so after searching if i select the row by using the button it will navigate the first tab page that is "gas" screen here if i tried to change the value like update and save the form it is not allowing me