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

Frm-40505 Oracle Error Unable To Perform Query

Contents

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 The time now is 21:18. In find receipt menu i only use parameter for "Receipt Dates". 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 have a peek here

If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. Re: FRM-40505: unable to perform query 623086 Feb 15, 2008 8:03 AM (in response to Tony Garabedian) oops sorry,new to the forum thanks prasad Like Show 0 Likes(0) Actions 11. I am using Forms 6i. 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

Ora 40505 Unable To Perform Query

Re: FRM-40505: unable to perform query 622640 Feb 13, 2008 8:32 AM (in response to Tony Garabedian) ok dname was the column i want to execute along with emp columns according Thanks Top This thread has been closed due to inactivity. 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

daniel perlmutter replied Nov 7, 2012 Hendracy hi You must check the line number 1743 to see what your are fetching By example if there is more than one receipt in hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Am calling a form from a menu but the when the form loads it returns the error unable to perform query. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator.

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 Unable To Perform Query 10g The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its WHERE clause at the Block level by using following code in PRE-QUERY trigger of the block BLK_CLA_COLUMBO_WORKBUFFER 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 Please turn JavaScript back on and reload this page.

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 Which is your master block, EMP or DEPT?? and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. 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." But if I

Frm-40505 Unable To Perform Query 10g

FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... That error appears. Ora 40505 Unable To Perform Query Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Re: How do I capture FRM-40505 when executing query? Frm 40505 Execute Query That error appears.

There is no access priveleges issue with this table. http://blogeurope.net/unable-to/frm-40505-oracle-error.php Like Show 0 Likes(0) Actions 8. You will find out the cause of your problem. Share Flag This conversation is currently closed to new comments. 4 total posts (Page 1 of 1)   + Follow this Discussion · | Thread display: Collapse - | Expand + Frm-40505 Unable To Perform Query 11g

PCMag Digital Group AdChoices unused 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 Edits are subject to review by community moderators. 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 Check This Out Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218631 is a reply to message #158193] Fri, 09 February 2007 01:23 [email protected] Messages:

Thanks in Advance for any helpful suggestions. Frm-40508 PCMag Digital Group AdChoices unused TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Can you help me capture this error/message/alert so that the user will not see it?

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:

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. 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... When i click "Find" button. Frm 40735 i want to display the values for all the above mentioned columns along with dname also.

You can simply press Shift+F1 to see what is the Query your Form builder has fired. Thanks, Amit Sharma Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85205 is a reply to message #85200] Wed, 09 June 2004 i want to display the values for all the above mentioned columns along with dname also. this contact form Check your SQl, as suggested already, by running this as an SQL statement.Check you have qualified the table names with the schema owner or have a synonym for tables in different

Action: Pressing [Display Error] provides more information, if it is available. Thanks much for helping me get this straightened out. 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 ) > 100 and (PIG_BASIS_ACCOUNTS.PIG_ID=:1) Tony Andrews http://tinyurl.com/tonyandrews Reply http://forums.oracle.com/forums/thread.jspa?threadID=616908Or go here:http://blogs.oracle.com/shay/2007/03/02/ 0Votes Share Flag Collapse - Reponse To Answer by john.a.wills · 6 years ago In reply to More info to your questio ...

View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and I'm not sure what we will do, but will hash it out and get back with actions taken. Tony Like Show 0 Likes(0) Actions 2. Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years?