Well anyhow, we got rid of the other validations and now we're running smoothly. Original answer by daniel perlmutter Nov 7, 2012 Contributors: Top You have a select like SELECT A INT0 B FROM C WHERE ?... Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218631 is a reply to message #158193] Fri, 09 February 2007 01:23 [email protected] Messages: After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query.
But I feel that it is trying to do that when I receive this message in the first block. The time now is 21:16. That means that hour where condition is not unique DANI Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Home | Invite Peers | More Oracle Groups Your account is ready. Cause: Processing error encountered. Amit Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85218 is a reply to message #85206] Wed, 09 June 2004 22:56 Himanshu Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. You will find out the cause of your problem.
But, have had no luck. Frm 40505 Execute Query For example from 01-Oct-2012 to 30-Oct-2012. This will open a window with the query which form tried to fire. 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:
You're making the assumption that both form_global.ctry_cd and form_global.part_nr are never NULL. (And never in 'programming-time' sometimes is remarkebly short...) The saying 'it works when I put it in sql*plus' doesn't Frm-40505+from Clause Query http://forums.oracle.com/forums/thread.jspa?threadID=616908Or go here:http://blogs.oracle.com/shay/2007/03/02/ 0Votes Share Flag Collapse - Reponse To Answer by john.a.wills · 6 years ago In reply to More info to your questio ... Everything looks okay. Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158170 is a reply to message #85200] Wed, 08 February 2006 16:19 RJ.Zijlstra Messages:
After going thru the entire discussion now I can see the exact error message after pressing Shift+F1. Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... Ora 40505 Unable To Perform Query and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. Frm-40505 Unable To Perform Query 10g Show 14 replies 1.
daniel perlmutter replied Nov 7, 2012 You have a select like SELECT A INT0 B FROM C WHERE ?.. have a peek at these guys Re: FRM-40505: unable to perform query 622640 Feb 13, 2008 7:13 AM (in response to 567066) Here is my issue i have two data blocks emp,dept(with the same values in the Sanjay Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218643 is a reply to message #218631] Fri, 09 February 2007 02:19 Littlefoot I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. Frm-40505 Unable To Perform Query 11g
In its bottom part you should be able to scroll through the whole statement that raised an error and compare columns with actual columns in your table. To start viewing messages, select the forum that you want to visit from the selection below. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php Kindly let me know why this is happening ???
That error appears. Frm-40508 Which is your master block, EMP or DEPT?? You should prevent it from happening in the first place rather than try to hide the fact that it has happened!
If this is your first visit, be sure to check out the FAQ by clicking the link above. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... i.e begin ...... ....... Frm 40735 One was a validation at table level and the other...
No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site Start a new thread here 4998634 Related Discussions ORACLE error: Unable to Perform Query Misc Receipt Unable to perform Transact Move Order (Serial Numbers) - which gives Fatal Failure (India Localization... http://jamisonsoftware.com/unable-to/frm-40505-oracle-error-unable-perform.php When i click "Find" button.
could any one show the solution for this 45263Views Tags: none (add) This content has been marked as final. Reply With Quote 03-16-04,11:18 #5 andrewst View Profile View Forum Posts Visit Homepage Moderator. Happily the FRM-40505 is gone! Re: FRM-40505: unable to perform query 622640 Feb 12, 2008 10:08 AM (in response to Tony Garabedian) Thanks for your reply tony but i need to populate the details for the
Top White Papers and Webcasts Popular 10 Critical Questions to ask a Manufacturing ERP Vendor Related Forrester Consulting Report: Empowered Customers Drive ...