40508 Error
Contents |
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 Create a frm-40508 unable to insert record solution Freelance Project Hire for a Full Time Job Ways to Get Help frm-40508 ora-01403 Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing ora 040508 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 UNABLE to INSERT display error key oracle forms error? Posted on 2003-01-16 Oracle Database 1 Verified Solution 7 Comments 16,232 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 Add new RECORD- FAILED!!!!');
Frm-40408 Database Commit Failure
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 on the items, etc). If your
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:
Frm-40505 Oracle Unable To Perform Query
22Registered: October 2012 Junior Member I have this error. To put it 40508 vc simply I have two blocks. Block1 contains two drop down list with PL/SQL statements for queries. Block2 contains 40508 zip code tabular form created from block wizard (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 https://www.experts-exchange.com/questions/20459898/why-do-i-get-FRM-40508-UNABLE-to-INSERT-error.html 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 into dummy1 table but when I execute the block1 - http://www.orafaq.com/forum/t/184531/ 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: 12320Registered: 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 prop
check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to http://www.dbforums.com/showthread.php?974427-simple-INSERT-FRM-40508 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 Profile View Forum Posts Registered unable to 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 write : FRM-40508 - ORACLE: ERROR UNABLE frm-40508 unable to 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 GhostMan View Profile View Forum Posts Registered User Join Date Sep 2003 Posts 156 Re: