However when i run the form on its own its able to execute the query. If you need any further info to solve this problem, plz revert. Begin ... ... i have tried as you told but it is not exucuting the value for dname.if i keep dname as non database item.it is only executing the columns for emp Like Show weblink
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 So I need to take this information to a team member and see what we can do. 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 Action: Pressing [Display Error] provides more information, if it is available.
The problem was with the code you, Tony, identified. EXCEPTION when others then LOG( l_query ); ... Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23
Can you help me capture this error/message/alert so that the user will not see it? Like Show 0 Likes(0) Actions 10. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 1:42 PM (in response to 622640) You need to have some sort of relation between the DEPT Block. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. 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
But, have had no luck. Frm-40505 Unable To Perform Query 10g All rights reserved. Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr. You can simply press Shift+F1 to see what is the Query your Form builder has fired.
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 Frm-40505+from Clause Query It shows "ORA-00904: invalid column name" and that is correct. LOG( l_query ); Set_property.... ... Always respect the original author.
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 The validation that was going on in the WHERE clause was also being done in two other places in the form. Ora 40505 Unable To Perform Query i.e begin ...... ....... Frm 40505 Execute Query 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
Home | Invite Peers | More Oracle Groups Your account is ready. http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php 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. Re: FRM-40505: unable to perform query Suhail Faraaz Aug 17, 2010 6:55 AM (in response to 791846) After you compile the form If it is 6i then press shift+f1 IF it If you're able to get the form without any errors then write execute_query in when_new_form_instance. Frm-40505 Unable To Perform Query 11g
You can not post a blank message. Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years? 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 check over here 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
After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. Frm-40508 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 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
and to populate the DNAME value, use the POST-QUERY trigger. 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. Set it to "No" it should work. Frm 40735 By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form.
Am calling a form from a menu but the when the form loads it returns the error unable to perform query. 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 FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... this content rachel ankory replied Sep 16, 2010 nothing in Show Errors ?
All Replies (8) Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... When i click "Find" button. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended. Re: FRM-40505: unable to perform query 567066 Feb 12, 2008 5:20 PM (in response to Tony Garabedian) Guess what you have to do is assuming ( if I inderstood your issue
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 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 Also below it you will find another error message like "Invalid column" or "nvalid No" etc. 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.
Top White Papers and Webcasts Popular Taking Business Intelligence to the Next Level Related Forrester Consulting Report: Empowered Customers Drive ... ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.ARP_MISC_CASH_DIST", line 1743 Thank You for your advice Join this group Best Answer Updated html error You have a Like Show 0 Likes(0) Actions 4. If this is your first visit, be sure to check out the FAQ by clicking the link above.
hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. 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 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 You should prevent it from happening in the first place rather than try to hide the fact that it has happened!
But, I am not sure where to effect that change (rectify column name), which is not matching with one of my database table column names. Copy the query from the Pop-up window and execute it on SQL prompt. by Peconet Tietokoneet · 6 years ago In reply to How do I find an Oracle e ... The SQL Statement in Error is: 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 ) and (PIG_BASIS_ACCOUNTS.PIG_ID=:1)
Cause: Processing error encountered. and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. 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: For example from 01-Oct-2012 to 30-Oct-2012.