As Himanshu already suggested, it could be that in some cases it would be something like '... = '; (A NULL value after one of the = signs) I would strongly Please remember to be considerate of other members. The point is, that at this moment you have too little information to get the real error cause. Home ERP About Hung Tran's blog ~ Sống trên đời sống cần có một tấm lòng… Search: How to solve FRM-40505: unable to perform queryerror 23 Monday May 2011 Posted by weblink
MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Forgot your password? Like Show 0 Likes(0) Actions 8. After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query.
My schema name is G_HRS, Table Name - HRS_MSTEMPLOYEE. You can not post a blank message. The only proof is seeing the values for exactly what they are, so logging and more logging...
BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference kevinsky View Member Profile Dec 2 2008, 09:35 AM Post #3 Advanced Member Group: Members Posts: 37 Joined: 22-October 04 From: Re: FRM-40505: unable to perform query 791846 Aug 17, 2010 6:04 AM (in response to 622640) i have an error FRM-40505: unable to perform query want solution plz Like Show 0 To start viewing messages, select the forum that you want to visit from the selection below. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters.
Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. Frm-40505+from Clause Query could any one show the solution for this 45263Views Tags: none (add) This content has been marked as final. But I feel that it is trying to do that when I receive this message in the first block. Regards Sridhar Rao Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
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: View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and Ora 40505 Unable To Perform Query In find receipt menu i only use parameter for "Receipt Dates". Frm 40505 Execute Query Thanks so much in advance for your help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE RCRAPP1_INFC_CODE IN ('ISIR','EDE')AND RCRAPP1_CURR_REC_IND = 'Y'AND (EXISTS (SELECT 'X' FROM RORSTAT WHERE RORSTAT_PIDM = RCRAPP1_PIDM AND RORSTAT_AIDY_CODE = RCRAPP1_AIDY_CODE AND
Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud have a peek at these guys Am calling a form from a menu but the when the form loads it returns the error unable to perform query. All rights reserved. rajthampi replied Nov 7, 2012 Unless this is a customized apps form, you shouldn't try to fix it yourself. Frm-40505 Unable To Perform Query 11g
Thanks much for your help. All product names are trademarks of their respective companies. Select a Product... http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and
If you are still unable to find out then post your Form & Table structure at firstname.lastname@example.org for investigation. Frm-40508 Buy/Market/Sell/Service Smarter eBook Avoiding the Shoebox: Managing Expenses in Small and ... There is no access priveleges issue with this table.
That means that hour where condition is not unique DANI Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Regards, Rob Zijlstra Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158193 is a reply to message #85200] Wed, 08 February 2006 The problem was with the code you, Tony, identified. Frm 40735 After going thru the entire discussion now I can see the exact error message after pressing Shift+F1.
Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query? Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are 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 ... this content For example from 01-Oct-2012 to 30-Oct-2012.
The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table. Re: FRM-40505: unable to perform query 622640 Feb 13, 2008 8:32 AM (in response to Tony Garabedian) ok dname was the column i want to execute along with emp columns according