prasadhoney07 replied Nov 7, 2012 Check your procedure APPS.ARP_MISC_CASH_DIST line 1743,there select query returns more than one rows so only you got that error Top Best Answer 0 Mark this reply 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. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query? 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 weblink
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 empYou're talking about 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 When i click "Find" button. 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
Set it to "No" it should work. Mitt kontoSökMapsYouTubePlayNyheterGmailDriveKalenderGoogle+ÖversättFotonMerWalletDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden It is currently Sat, 15 Oct 2016 10:29 pm Advanced search Principal Forum User Control Panel Search FAQ Members Reply With Quote 03-16-04,11:18 #5 andrewst View Profile View Forum Posts Visit Homepage Moderator. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. If you are still unable to find out then post your Form & Table structure at email@example.com for investigation.
Edits are subject to review by community moderators. Frm 40505 Execute Query The problem was with the code you, Tony, identified. I would also like to look at the query as the Form has constructed it. 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
When i click "Find" button. Frm-40505+from Clause Query MHE Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158139 is a reply to message #85206] Wed, 08 February 2006 11:24 karan.shandilya END; LOG(...) is of course your own standard logging procedure, as I assume you have one. gurujothi replied Nov 7, 2012 Hi Hendracy, As everyone mentioned,Your select ..into should be a reason for this, so check your code, If you know your query could return more than
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 Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr. Ora 40505 Unable To Perform Query For example from 01-Oct-2012 to 30-Oct-2012. Frm-40505 Unable To Perform Query 10g 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
The SQL Statement in Error is: 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 PIG_BASIS_ACCOUNTS.ACCOUNT FROM BASIS_ACCOUNTS_VW, PIG_BASIS_ACCOUNTS WHERE BASIS_ACCOUNTS_VW.FY = PIG_BASIS_ACCOUNTS.FY ) and (PIG_BASIS_ACCOUNTS.PIG_ID=:1) have a peek at these guys and to populate the DNAME value, use the POST-QUERY trigger. Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 What do you see when you select Help - Display Error from the form menu just after you get the 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 Frm-40505 Unable To Perform Query 11g
All rights reserved. Like Show 0 Likes(0) Actions 4. 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 http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me...
Start by running this query outside of Forms, in SQL*Plus!Did you do a "show errors" to see your error?QUOTE FRM-40505: ORACLE error: unable to perform query. Frm-40508 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 Forgot your password?
When i click "Find" button. i want to display the values for all the above mentioned columns along with dname also. i want to display the values for all the above mentioned columns along with dname also. Frm 40735 Home | Invite Peers | More Oracle Groups Your account is ready.
You should prevent it from happening in the first place rather than try to hide the fact that it has happened! 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 what i saw it RANDOMLY fails (rarely) before this code ---------------------- set_block_property('BLK_CLA_COLUMBO_WORKBUFFER', DEFAULT_WHERE, l_query); ---------------------- It seems sometime the set_block_property is not able to find the database table assigned to this this content 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
hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. EXCEPTION when others then LOG( l_query ); ... Well anyhow, we got rid of the other validations and now we're running smoothly. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle How do I capture FRM-40505 when executing query?
Everything looks okay. Re: FRM-40505: unable to perform query 622640 Feb 13, 2008 7:14 AM (in response to Tony Garabedian) my master table was dept(as same as the basetables) deptno is my common column Please enter a title. Please remember to be considerate of other members.
and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas.