Show 14 replies 1. instead create a SR to oracle and let them provide your datafix. When i click "Find" button. 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 http://blogeurope.net/unable-to/frm-40505-oracle-error-unable-to-perform-query.php
If you are still unable to find out then post your Form & Table structure at firstname.lastname@example.org for investigation. But I feel that it is trying to do that when I receive this message in the first block. 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 Cause: Processing error encountered.
Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158101 is a reply to message #158099] Wed, 08 February 2006 08:49 Maaher Messages: Donald K. 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 Where the select result is more than one row.
Thanks much for your help. However when i run the form on its own its able to execute the query. Re: FRM-40505: unable to perform query Tony Garabedian Feb 15, 2008 7:26 AM (in response to 622640) Thanks for your reply tony but i need to populate the details for the Kindly respond at the earliest.
One was a validation at table level and the other... Frm-40505+from Clause Query The point is, that at this moment you have too little information to get the real error cause. 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 Tony Like Show 0 Likes(0) Actions 2.
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: If necessary, contact your DBA. -------------------- Hope this helps. . . Ora 40505 Unable To Perform Query The problem was with the code you, Tony, identified. Frm 40505 Execute Query Which is your master block, EMP or DEPT??
That means that hour where condition is not unique DANI Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... http://blogeurope.net/unable-to/frm-40505-error-de-oracle.php The time now is 21:22. Mitt kontoSökMapsYouTubePlayNyheterGmailDriveKalenderGoogle+ÖversättFotonMerWalletDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden Are you passing any parameters to the called form from calling form ? Frm-40505 Unable To Perform Query 11g
This will open a window with the query which form tried to fire. siddarath replied Sep 16, 2010 Please compile the form Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... 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. Check This Out Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Select a Product... Frm-40508 Everytime I try to execute, I get "FRM-40505 Oracle Error: unable to perform query". Kindly advise.
All product names are trademarks of their respective companies. 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 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 Frm 40735 i was sorry for not explaining u correctly Like Show 0 Likes(0) Actions 9.
Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years? 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. Home | Invite Peers | More Oracle Groups Your account is ready. this contact form Reply With Quote 03-16-04,11:18 #5 andrewst View Profile View Forum Posts Visit Homepage Moderator.
Thanks Top This thread has been closed due to inactivity. For example from 01-Oct-2012 to 30-Oct-2012. by Peconet Tietokoneet · 6 years ago In reply to How do I find an Oracle e ... 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