frm-40510 oracle error South Dennis New Jersey

Address 303 Gravel Hole Rd, Cape May Court House, NJ 08210
Phone (609) 408-8685
Website Link
Hours

frm-40510 oracle error South Dennis, New Jersey

Or mabe you could give me a sample how to check integrity? Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Re: Error: FRM-40510: ORACLE error: unable to DELETE record Amatu Allah Neveen Ebrahim Nov 16, 2010 9:01 PM (in response to InoL) Hello it's Solved... FRM-40401 occurs because Oracle Forms has no records to delete and no changes to save. 0 LVL 1 Overall: Level 1 Message Author Comment by:Solve2004-10-28 I still get error message

to that display item and the following code in post-Query which is the newest BEGIN DECLARE CURSOR c_get_val IS SELECT WH_T_ITEMS.ITEM_QTY , WH_ITEMS.ITEM_NAME , WH_ITEMS.ITEM_ID FROM WH_T_ITEMS, WH_ITEMS , Re: Error: FRM-40510: ORACLE error: unable to DELETE record InoL Nov 16, 2010 6:45 PM (in response to Amatu Allah Neveen Ebrahim) Well, I'll be .... Get 1:1 Help Now Advertise Here Enjoyed your answer? But I got a message 'No change to save', while executing this procedure...

What would be solution in such situation? You can see what it is checking for and you can write your own: BEGIN IF MOZEM_MAZAT_REKL(0)=1 THEN RAISE Form_Trigger_Failure; END IF; END; -- this part is generated by Designer Same code is working fine in forms 6i application. Like Show 0 Likes(0) Actions 29.

Check the privileges on the master table. Select a Product... Why do you have a separate delete statement? For know, I put such code: delete_record; commit; execute_query(no validate); s. 0 LVL 22 Overall: Level 22 Oracle Database 19 Message Active 1 day ago Expert Comment by:Henka2004-10-25 Here is

Are you issuing delete record on master block. Event if there was only one non deletable record, I see all deleted records are recovered. When I press Yes, I got an error FRM-40510... What does display error in the help menu show when you get the error?

Re: Error: FRM-40510: ORACLE error: unable to DELETE record Amatu Allah Neveen Ebrahim Nov 16, 2010 5:13 PM (in response to InoL) Thanks InoL, but i am sorry i confused u For example, you cannot update views that are based on multiple tables. Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation I had to close and reopen the screen. @cookiemonster - I'm sorry, I'm not sure how to trace forms session.

All rights reserved. So, problem is when we have 2 delete statements here. Please enter a title. As that message has a level of 5, this message will not come once the level is set to more than 5.

Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support CommunityOPN Cloud ConnectionOracle Employee CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: This ensures that the record to be deleted has input focus. Record: 1/1 Oracle and Java are registered trademarks of Oracle and/or its affiliates. Re: Error: FRM-40510: ORACLE error: unable to DELETE record InoL Nov 16, 2010 6:33 PM (in response to Amatu Allah Neveen Ebrahim) yesss when i remopve the cascade delete i got

Show 29 replies 15. But still don't like like they work :) s. 0 LVL 1 Overall: Level 1 Message Author Comment by:Solve2004-10-25 I will leave this question open for some times, mabe I'll Examples are given for duplicating to the same machine and to different machines Oracle Database Advertise Here 771 members asked questions and received personalized solutions in the past 7 days. Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation

s. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. You don't see a reason why you can't delete record. Featured Post Looking for New Ways to Advertise? Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle

Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more. Thanks all Report message to a moderator Re: FRM - 40510 - unable to delete record in App server [message #620314 is a reply to message #620312] Thu, i will build the module fromthe begining and test step by step. Report message to a moderator Re: FRM - 40510 - unable to delete record in App server [message #619530 is a reply to message #619522] Wed, 23 July

But still a lot if problems with this deletion :(( Sometimes I don't ness execute query, when deletion is success ... When you set these properties to True or On, Oracle Forms navigates to the button, places input focus in it, and tries to delete records in the button's block. So if it is something wrong with deletion you will receive immidiatelly respond. I would expect a message like 'cannot delete record while child records exists' when you try to delete a master record.

Press again 'Remove' and again 'Remove' to delete more records. Like Show 0 Likes(0) Actions 28. Trying to delete record in such way: I put this code to key-delrec trigger delete from MySchema.MyTable where MyTable.ID = :MyBlock.ID ? Edited by: InoL on Nov 16, 2010 1:33 PM Like Show 0 Likes(0) Actions 24.

For commit - If you use Remove button then after pressing it press Save button - it is in fact commit. Views cannot be updated if Oracle8 cannot trace a row and column in the view back to its corresponding row and column in the base table. Re: Error: FRM-40510: ORACLE error: unable to DELETE record Amatu Allah Neveen Ebrahim Nov 17, 2010 1:57 PM (in response to InoL) there is a difference between the origional post and In When-new-form-instance you can code :system.message_level := 10; 0 LVL 1 Overall: Level 1 Message Author Comment by:Solve2004-10-25 So, for me it is enought to create key-delrec and put such

Would like to know what is happening in this case. s. 0 LVL 22 Overall: Level 22 Oracle Database 19 Message Active 1 day ago Expert Comment by:Henka2004-10-27 What does it mean that you cannot delete record - is there But i would prefer this: -- add here tests if record can be deleted delete_record; commit; 0 LVL 1 Overall: Level 1 Message Author Comment by:Solve2004-10-25 There is such error Please try the request again.

Again, this is visible in display_error, so please give us all information.