Home > Unable To > Ora 40505 Unable To Perform Query

Ora 40505 Unable To Perform Query

Contents

Oracle Forms Survey Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com Your ON-ERROR trigger should look something like this: PHP Code: DECLARE
v_errorNUMBER:=ERROR_CODE;
weblink

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 Kindly let me know why this is happening ??? 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: 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:

Ora 40505 Unable To Perform Query

Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query? To start viewing messages, select the forum that you want to visit from the selection below. EXCEPTION when others then LOG( l_query ); ... Happily the FRM-40505 is gone!

I have tried coding the Application Logic Events for ON-ERROR and ON-MESSAGE at the form level and module component level to capture this. More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Aug 17, 2010 6:55 AM by Suhail Faraaz FRM-40505: unable to perform query 622640 Feb Cause: Processing error encountered. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. The validation that was going on in the WHERE clause was also being done in two other places in the form.

hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Donald K. HTH Regards Himanshu Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85206 is a reply to message #85205] Wed, 09 June 2004 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

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. Frm-40505+from Clause Query If necessary, contact your DBA. -------------------- Hope this helps. . . Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site Home ERP About I'm not sure what we will do, but will hash it out and get back with actions taken.

Frm 40505 Execute Query

Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM Edits are subject to review by community moderators. Ora 40505 Unable To Perform Query For example from 01-Oct-2012 to 30-Oct-2012. Frm-40505 Unable To Perform Query 10g Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Re: How do I capture FRM-40505 when executing query?

After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. have a peek at these guys 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. Please remember to be considerate of other members. You should prevent it from happening in the first place rather than try to hide the fact that it has happened! Frm-40505 Unable To Perform Query 11g

Start a new thread here 4998634 Related Discussions ORACLE error: Unable to Perform Query Misc Receipt Unable to perform Transact Move Order (Serial Numbers) - which gives Fatal Failure (India Localization... Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table." My question is check over here That's why the Form is unable to query your table, it's not finding a column called "ename" in the table.

When i click "Find" button. Frm-40508 And I might be a very old and mistrusting programmer, but as long as I do not see the l_query in a logfile, I do not believe in the l_query 'you That error appears.

The variable form_global.part_nr & form_global.ctry_cd are never Null because i assign them before firing query over this erroroneous block and i debugged the query, it always hold the string with ctry_cd

As I suggested to you as sson as you get this error Press Shift+F1. 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. Like Show 0 Likes(0) Actions 8. Frm 40735 Maggie Reply With Quote 03-17-04,16:59 #9 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 Well, I said I'd let you know the

HTH Regards Himanshu Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158099 is a reply to message #85218] Wed, 08 February 2006 The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table. In find receipt menu i only use parameter for "Receipt Dates". this content Thanks so much in advance for your help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE RCRAPP1_INFC_CODE IN ('ISIR','EDE')AND RCRAPP1_CURR_REC_IND = 'Y'AND (EXISTS (SELECT 'X' FROM RORSTAT WHERE RORSTAT_PIDM = RCRAPP1_PIDM AND RORSTAT_AIDY_CODE = RCRAPP1_AIDY_CODE AND

Forgot your password? Everything looks okay. instead create a SR to oracle and let them provide your datafix.