Home > Unable To > Ora 40505 Unable To Perform Query

Ora 40505 Unable To Perform Query

Contents

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 After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. Karan. 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... Source

As Himanshu already suggested, it could be that in some cases it would be something like '... = '; (A NULL value after one of the = signs) I would strongly For example from 01-Oct-2012 to 30-Oct-2012. 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. 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

Ora 40505 Unable To Perform Query

There is no access priveleges issue with this table. Cause: Processing error encountered. Share Flag This conversation is currently closed to new comments. 4 total posts (Page 1 of 1)   + Follow this Discussion · | Thread display: Collapse - | Expand + I'm not sure what we will do, but will hash it out and get back with actions taken.

Tony Andrews http://tinyurl.com/tonyandrews Reply With Quote 03-16-04,12:22 #6 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 This is what I get when MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-16-04,10:25 #1 mhamilton View Profile Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. 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.

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 Frm 40505 Execute Query Re: FRM-40505: unable to perform query 791846 Aug 17, 2010 6:04 AM (in response to 622640) i have an error FRM-40505: unable to perform query want solution plz Like Show 0 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 Well anyhow, we got rid of the other validations and now we're running smoothly.

That error appears. Frm-40505+from Clause Query hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Kindly respond at the earliest. So I need to take this information to a team member and see what we can do.

Frm 40505 Execute Query

That error appears. You're now being signed in. Ora 40505 Unable To Perform Query and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. Frm-40505 Unable To Perform Query 10g Please type your message and try again.

Home | Invite Peers | More Oracle Groups Your account is ready. this contact form Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? If necessary, contact your DBA. -------------------- Hope this helps. . . 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 Frm-40505 Unable To Perform Query 11g

Am working in Designer 6i Forms. 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 have a peek here Select a Product...

Please let us know what your solution will be. Frm-40508 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? 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

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.

Copy the query from the Pop-up window and execute it on SQL prompt. In find receipt menu i only use parameter for "Receipt Dates". It shows "ORA-00904: invalid column name" and that is correct. Frm 40735 You're making the assumption that both form_global.ctry_cd and form_global.part_nr are never NULL. (And never in 'programming-time' sometimes is remarkebly short...) The saying 'it works when I put it in sql*plus' doesn't

Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. After finding the existing record I want in the parent table (first block) I go to the child table (second block) and then select a child that I want to be I do not know what could be wrong in the parent/child relationship between the tables or blocks. Check This Out Donald K.

hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. For example from 01-Oct-2012 to 30-Oct-2012.