i was sorry for not explaining u correctly There's a big difference between ename and dname, first I suggest you read [url http://blogs.oracle.com/shay/2007/03/02]The 10 Commandments on OTN Forum posting and the Thanks Top This thread has been closed due to inactivity. In find receipt menu i only use parameter for "Receipt Dates". i have tried as you told but it is not exucuting the value for dname.if i keep dname as non database item.it is only executing the columns for emp Like Show http://blogeurope.net/unable-to/frm-40505-oracle-error-unable-to-perform-query.php
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: 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 Thanks much for your help. That's why the Form is unable to query your table, it's not finding a column called "ename" in the table.
Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Well that SQL is certainly invalid: SELECT ROWID, PIG_BASIS_ACCOUNTS.FY, PIG_BASIS_ACCOUNTS.ACCOUNT, PIG_BASIS_ACCOUNTS.ID, PIG_BASIS_ACCOUNTS.PIG_ID, PIG_BASIS_ACCOUNTS.CREATE_DATE, PIG_BASIS_ACCOUNTS.CREATED_BY FROM PIG_BASIS_ACCOUNTS PIG_BASIS_ACCOUNTS WHERE ( SELECT If this is your first visit, be sure to check out the FAQ by clicking the link above. Happily the FRM-40505 is gone! Exception when too_many_rows then --put the message here End; Regards, Guru Top This thread has been closed due to inactivity.
Register Help Remember Me? Join this group Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years? 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. Oracle Error 40505 I can go into the Database and see that the correct relationship exists.
Action: Pressing [Display Error] provides more information, if it is available. Frm 40505 Execute Query I'm not sure what we will do, but will hash it out and get back with actions taken. 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 hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form.
Tony Andrews http://tinyurl.com/tonyandrews Reply With Quote 03-16-04,10:56 #4 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 It happens when the Parent table Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Which is your master block, EMP or DEPT?? Maybe a developer can help you . . . 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
As I suggested to you as sson as you get this error Press Shift+F1. Like Show 0 Likes(0) Actions 4. Ora 40505 Unable To Perform Query Re: FRM-40505: unable to perform query 567066 Feb 12, 2008 5:20 PM (in response to Tony Garabedian) Guess what you have to do is assuming ( if I inderstood your issue Frm-40505 Unable To Perform Query 10g In find receipt menu i only use parameter for "Receipt Dates".
Select a Product... his comment is here PCMag Digital Group AdChoices unused HelpInfo Want to narrow your search? So the trin formed will be as follows: 'Where ctry_cd= AND part_nr = ' which is an erroneous string. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Frm-40505 Unable To Perform Query 11g
Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... 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. END; LOG(...) is of course your own standard logging procedure, as I assume you have one. this contact form EXCEPTION when others then LOG( l_query ); ...
Donald K. Frm-40508 One was a validation at table level and the other... and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas.
Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Start a new thread here 3761062 Related Discussions Problem with Execute_Query Problem In Execute_Query execute_query; Executing a query when a tab has focus FRM 40735 - On Error Trigger Raised Unhandled There is no access priveleges issue with this table. Frm 40735 Top White Papers and Webcasts Popular 10 Critical Questions to ask a Manufacturing ERP Vendor Related Forrester Consulting Report: Empowered Customers Drive ...
Subscribe Entries (RSS) Comments (RSS) Archives December 2011 August 2011 July 2011 May 2011 Categories ERP My entry Oracle Uncategorized Meta Register Log in Blog at WordPress.com. %d bloggers like this: By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form. Maggie Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft navigate here All product names are trademarks of their respective companies.
When i click "Find" button. PCMag Digital Group AdChoices unused 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 Regards Sridhar Rao Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Like Show 0 Likes(0) Actions 8.
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 If necessary, contact your DBA. -------------------- Hope this helps. . . Show 14 replies 1. Niether of those references leads anywhere useful. 0Votes Share Flag Collapse - Help/Display Error in Sungard's Banner INB, by john.a.wills · 6 years ago In reply to How do I find
Home | Invite Peers | More Oracle Groups Your account is ready. So I need to take this information to a team member and see what we can do. Where the select result is more than one row. i.e begin ...... .......
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. 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." But if I and to populate the DNAME value, use the POST-QUERY trigger. This solves the problem I set, although after some investigation I may be back with a deeper question. 0Votes Share Flag Back to Web Development Forum 4 total posts (Page 1
Oracle Forms Survey Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com