40505 Oracle Error Unable To Perform Query
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 and try again. More discussions in Forms frm-40505 oracle error unable to perform query All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Aug 17, 2010 6:55 ora 40505 unable to perform query AM by Suhail Faraaz FRM-40505: unable to perform query 622640 Feb 12, 2008 6:26 AM i am having two data blocks Emp,Dept(default tables) i am frm 40505 execute query 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 exuting query and it is showing error- unable to perform query. could any one show
Frm-40505 Unable To Perform Query 10g
the solution for this 44410Views 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 the Form is unable to query your table, it's not finding a column called "ename" in the table. Set it to "No" it oracle error 40505 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) Actions 5. 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 database.i am giving the basetables for ur understanding.) i have joined the two databl
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development ora-01722: invalid number frm-40505: oracle error: unable to perform query. Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP
Frm-40508
Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Richard JoeTorre
Ora-00904 Invalid Identifier
bracke Ramnath.Awate DukeGanote Locutus Nikki Klein Dennis Stevenson AbhaiTripathi Craig Borysowich Clinton Jones bluesguyAZ59 iudithm mircea_luca Adrian_Grigoriu blrvenkat COMPANIES CloudLock Trend Micro Incorporated Citrix Panaya Inc. View All Topics View All Members View All Companies Toolbox https://community.oracle.com/thread/618908?start=0&tstart=0 for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Forms, including migration, configuration, performance testing, inserting files and records, and displaying reports. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 taken If this is your account,sign in here Email address Username Between 5 and 30 characters. 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 Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... i have problem when i revers receipt in receipt batch after that i got message error like this: FRM-40505: ORACLE error: unable to perform query. ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.ARP_MISC_CASH_DIST", line 1743 Thank You for your advice Join this group Best Answer Updated html error You have a select like SELECT A INT0 B FROM C WHERE ?.. Where the select result is more than one row. 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. Always respect the original author. Edits are subject to review by community moderators. Original answer by daniel perlmutt
first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the http://www.dbforums.com/showthread.php?988718-How-do-I-capture-FRM-40505-when-executing-query register link above to proceed. To start viewing messages, select the forum https://hutavi.wordpress.com/2011/05/23/how-to-solve-frm-40505-unable-to-perform-query-error/ that you want to visit from the selection below. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded unable to Mode 03-16-04,10:25 #1 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 Unanswered: How do I capture FRM-40505 when executing query? Am working in Designer 6i Forms. After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. I have tried coding the Application Logic Events unable to perform for ON-ERROR and ON-MESSAGE at the form level and module component level to capture this. But, have had no luck. Can you help me capture this error/message/alert so that the user will not see it? Thanks, Maggie Reply With Quote 03-16-04,10:33 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 Does the query succeed when run from SQL*Plus as the same user who is running the form? Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Re: How do I capture FRM-40505 when executing query? Your ON-ERROR trigger should look something like this: PHP Code: DECLARE
v_errorNUMBER:=ERROR_CODE;
v_typeVARCHAR2(3):=ERROR_TYPE;
v_textVARCHAR2(80):=ERROR_TEXT;
BEGIN
IF
comment TagsFRM-40505, unable to perform query error May be there are something wrong with datatype, Try to re-run Datablock Wizard ^^ good luck Hutavi, Share this:TwitterFacebookLike this:Like Loading... Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... 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 commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. 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: