Home > Unable To > Frm-40505 Oracle Error Unable Perform

Frm-40505 Oracle Error Unable Perform

Contents

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 himan_bharadwaj@hotmail.com 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.

Ora 40505 Unable To Perform Query

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.

Toolbox.com is not affiliated with or endorsed by any company listed at this site. FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Report message to a moderator Previous Topic: pl/sql looping Next Topic: About Image Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Please turn JavaScript back on and reload this page.

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.

Frm-40505 Unable To Perform Query 10g

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.

Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech

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