Error 40505
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message ora 40505 unable to perform query and try again. More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived
Frm 40505 Execute Query
14 Replies Latest reply on Aug 17, 2010 6:55 AM by Suhail Faraaz FRM-40505: unable to perform query 622640 Feb 12, 2008
Frm-40505 Unable To Perform Query 10g
6:26 AM i am having two data blocks Emp,Dept(default tables) i am creating master-detail relationship between two blocks and copying ename into dept. displaying the dept with the feilds of dept table and ename on the canvas
Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query.
exuting query and it is showing error- unable to perform query. could any one show the solution for this 44904Views Tags: none (add) This content has been marked as final. Show 14 replies 1. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 7:51 AM (in response to 622640) Just a wild guess regardless what you are trying to do; you have set the "ename" "Databse Item" property to "Yes". That's why frm-40505+from clause query the Form is unable to query your table, it's not finding a column called "ename" in the table. Set it to "No" it should work. Tony Like Show 0 Likes(0) Actions 2. 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 field ename also prasad Like Show 0 Likes(0) Actions 3. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 1:42 PM (in response to 622640) You need to have some sort of relation between the DEPT Block. Which is your master block, EMP or DEPT?? Like Show 0 Likes(0) Actions 4. 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 corretly, else please explain in detail) dept table as master block and emp as detail block on the detail block's empno field/item property sheet , there is a column called " copy value from item" put in a value there as "dept.empno" ( again assuing the empno is the joining factor) or you have to do for all the columns that you want to link/join. Thanks sheik Like Show 0 Likes(0) Acti
United States Australia United Kingdom Japan Newsletters Forums Resource Library Tech Pro Free Trial Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic Search GO frm-40508 Topics: CXO Cloud Big Data Security Innovation Software Data Centers Networking Startups Tech ora-00904 invalid identifier & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro Free Trial Editions: US United ora-00942 States Australia United Kingdom Japan Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic | Forums | Web Development Web Development Register Now or Log In to https://community.oracle.com/thread/618908 post Welcome back, My Profile Log Out Recent Activity FAQs Guidelines Question 0 Votes Locked How do I find an Oracle error when I get FRM-40505 in an Oracle Form? By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form. I know which query is inducing the error message, but I see nothing wrong with it, http://www.techrepublic.com/forums/discussions/how-do-i-find-an-oracle-error-when-i-get-frm-40505-in-an-oracle-form/ and have successfully run it in SQLPlus. I would like to see the ORA error number and message, but when i install an On-Error trigger routine for this purpose I get ORA-00000 operation successful, which cannot be right. I would also like to look at the query as the Form has constructed it. What kind of trigger or other trace can I use? Share Flag This conversation is currently closed to new comments. 4 total posts (Page 1 of 1) + Follow this Discussion · | Thread display: Collapse - | Expand + All Answers Collapse - More info to your question here.... by Peconet Tietokoneet · 6 years ago In reply to How do I find an Oracle e ... 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 ... 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 an Oracle e ... and possibly in other Oracle Forms environments, shows the query as construct
Visio Microsoft https://groups.google.com/d/topic/comp.databases.oracle.tools/pVFEFf59_g0 Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems unable to Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw unable to perform Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen