Home > Unable To > Unable To Perform Query Oracle Error

Unable To Perform Query Oracle Error

Contents

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. Subscribe Entries (RSS) Comments (RSS) Archives December 2011 August 2011 July 2011 May 2011 Categories ERP My entry Oracle Uncategorized Meta Register Log in Blog at WordPress.com. %d bloggers like this: displaying the dept with the feilds of dept table and ename on the canvas exuting query and it is showing error- unable to perform query. 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. http://centralpedia.com/unable-to/unable-to-perform-ocr-in-english-error.html

Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398607 is a reply to message #398598] Thu, 16 April 2009 22:22 [email protected] Messages: 22Registered: Are you passing any parameters to the called form from calling form ? Well anyhow, we got rid of the other validations and now we're running smoothly. hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. https://community.oracle.com/thread/618908

Ora 40505 Unable To Perform Query

Forgot your password? Am calling a form from a menu but the when the form loads it returns the error unable to perform query. You can also try to update or delete this record later.

Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398610 is a reply to message #398607] Thu, 16 April 2009 22:33 [email protected] Messages: 22Registered: After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. What kind of trigger or other trace can I use? Oracle Error 40505 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

Report message to a moderator Re: Help reqd. Frm-40505 Unable To Perform Query 10g 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 Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site TechRepublic Search GO http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 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

hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. 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 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 If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ.

Frm-40505 Unable To Perform Query 10g

Select a Product... http://www.helpinfo.com/index.jsp?k2dockey=1021033095251925207&T1=%20%20&titlestring=null&T2=null&taxlevelValue=null&isbrowse=false&taxlevel=null&typeofsearch=null&LastQuery=null&T3=..&T4=null&startat=1&Curr 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) Ora 40505 Unable To Perform Query 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 Frm 40505 Execute Query 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

Do you need to concatenate quotes around the item names so that it looks like "Product_Legal_Name = ''||:B00.Pln||'''"? this content For this reason I have taken an approach of creating check boxes on a new window/canvas. When i click "Find" button. 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. Frm-40505 Unable To Perform Query 11g

  • One was a validation at table level and the other...
  • 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 empYou're talking about
  • Everytime I try to execute, I get "FRM-40505 Oracle Error: unable to perform query".
  • I can go into the Database and see that the correct relationship exists.
  • David Report message to a moderator Re: Help reqd.

It again has a LOV. Where the select result is more than one row. Join this group Popular White Paper On This Topic On-demand vs. weblink Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398640 is a reply to message #398623] Fri, 17 April 2009 01:10 djmartin Messages: 10180Registered:

I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. Frm-40505+from Clause Query Toolbox.com is not affiliated with or endorsed by any company listed at this site. could you please help me David.

Please post the table structure.

Re: FRM-40505: unable to perform query Ade2 Apr 8, 2008 4:54 PM (in response to 628374) Make tot a display item and in your post-change :tot := :salary + nvl(:commission_pct,'0'); Like Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud This solves the problem I set, although after some investigation I may be back with a deeper question. 0Votes Share Flag Back to Web Development Forum 4 total posts (Page 1 Frm-40508 PCMag Digital Group AdChoices unused HelpInfo Want to narrow your search?

Top White Papers and Webcasts Popular Best Practices for a BI and Analytics Strategy Related Forrester Consulting Report: Empowered Customers Drive ... i.e begin ...... ....... I do not know what could be wrong in the parent/child relationship between the tables or blocks. http://centralpedia.com/unable-to/unable-to-perform-search-google-earth-detected-a-network-error.html Home | Invite Peers | More Oracle Groups Your account is ready.

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. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398598 is a reply to message #398531] Thu, 16 April 2009 20:59 djmartin Messages: 10180Registered: Thanks, Vishal Attachment: screen1.GIF (Size: 26.04KB, Downloaded 429 times) Report message to a moderator Re: Help reqd. 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.

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... 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 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... Always respect the original author.

Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #399412 is a reply to message #398791] Wed, 22 April 2009 02:37 djmartin Messages: 10180Registered: 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 Report message to a moderator Re: Help reqd. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query?

Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Well that SQL is certainly invalid: 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 The time now is 20:46. Home | Invite Peers | More Oracle Groups Your account is ready. Home ERP About Hung Tran's blog ~ Sống trên đời sống cần có một tấm lòng… Search: How to solve FRM-40505: unable to perform queryerror 23 Monday May 2011 Posted by

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. FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398791 is a reply to message #398640] Fri, 17 April 2009 10:06 [email protected] Messages: 22Registered: 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

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 Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. The validation that was going on in the WHERE clause was also being done in two other places in the form. Report message to a moderator Re: Help reqd.