Oracle Error Frm-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 not post a blank message. Please type your message and try frm-40508 ora-01403 again. More discussions in Forms All PlacesDevelopment ToolsForms 5 Replies Latest reply on Jul 14, 2016 display error key oracle forms 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 ora 040508 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 919Views Tags: none (add) This content has been marked
Frm-40408 Database Commit Failure
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 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 40508 vc 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 : ORACLE error: unable to INSERT record 3273964 Jul 14, 2016 12:48 AM (in response to 3273964) Thanks Everybody For Trying To Help, And It's My First Oracle Project So I Am Still A Beginner That's Why I Couldn't Explain That Much For My Problem.But I Already Solved The Problem With Call_Form.Thanks For Reading. Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Commun
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 ora 01400 cannot insert null Create a Freelance Project Hire for a Full Time Job Ways to
40508 Zip Code
Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services
Ora 00001 Unique Constraint Violated
Groups Website Testing Store Headlines Experts Exchange > Questions > why do i get FRM-40508 UNABLE to INSERT error? Want to Advertise Here? Solved why do i get FRM-40508 https://community.oracle.com/thread/3948948 UNABLE to INSERT error? Posted on 2003-01-16 Oracle Database 1 Verified Solution 7 Comments 16,438 Views Last Modified: 2013-12-12 I my form, everytime i try to do an insert record, i get the FRM-040508 error. The sql for the WHEN-BUTTON-PRESSED triger is as follows simple: create_record; IF NOT Form_Success THEN Message ('NOPAY https://www.experts-exchange.com/questions/20459898/why-do-i-get-FRM-40508-UNABLE-to-INSERT-error.html Add new RECORD- FAILED!!!!'); END IF; commit; BUt i keep getting FRM-40508 error and dont understand why or waht to look for. Any ideas? 0 Question by:joekeri Facebook Twitter LinkedIn Google LVL 1 Best Solution byramsdesk Instead of Create_record, try insert_record. rgds Go to Solution 7 Comments LVL 3 Overall: Level 3 Oracle Database 3 Message Expert Comment by:rramineni2003-01-16 Check if any constraints are being violated at the database level. Try inserting the data from sqlplus using the values that are supplied from form. One possibility is that you are trying to insert causing duplicated primary key. Was the form a base block form and you are trying to insert using explicit statements?. 0 Message Author Comment by:joekeri2003-01-16 The form is adat abase block. I have two buttons on it that execute SQl to CREATE_RECORD and ht eother to DELETE RECORD. 0 LVL 4 Overall: Level 4 Oracle Database 4 Message Expert Comment by:stemu20002003-01-16 CREATE_RECORD; built-in creates an empty record (using default values set
check out the FAQ by clicking the link above. You may have to register before you can post: click the register link http://www.dbforums.com/showthread.php?974427-simple-INSERT-FRM-40508 above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: simple INSERT - FRM-40508 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-13-03,15:57 #1 xxxfox View oracle error Profile View Forum Posts Registered User Join Date Dec 2003 Posts 1 Unanswered: simple INSERT - FRM-40508 Hi Im new in oracle and I have simple problem I want to do INSERT with defined data : sql command is : INSERT INTO zamestnanec (login,pass,jmeno,prijmeni,titul,ulice,cp,mesto,ps c,telefon,plat,id_odeleni) values ('ccccc','koko','Karel','Venda','ing','Kounicova', '2','Bruntal','79201','608925995','12000','4'); but when i write this in form builder in when-button-pressed it will oracle error frm-40508 write : FRM-40508 - ORACLE: ERROR UNABLE TO INSERT RECORD where is problem ? Reply With Quote 12-13-03,16:08 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 Problem exists between keyboard and chair. No OS or OS version specified. No Oracle product or version specified. No version of DB into which the INSERT is going is specified. It might be a real bug, depending upon version of product & DB. Poster expects us to guess at details that only he knows. Your On Your Own (YOYO)! Reply With Quote 12-17-03,02:33 #3 satish_ct View Profile View Forum Posts Visit Homepage Registered User Join Date Nov 2003 Location Bangalore, INDIA Posts 333 Hi, A fatal error occurred while Oracle Forms was trying to insert a record. The table associated with the current block of the form might not exist or username might not have authority to perform the specified action on the table. SATHISH . Reply With Quote 12-17-03,06:25 #4 Ghost