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 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 Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. 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 weblink
Anyone with help. You can simply press Shift+F1 to see what is the Query your Form builder has fired. Set it to "No" it should work. 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
That error appears. All product names are trademarks of their respective companies. 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 Toolbox.com is not affiliated with or endorsed by any company listed at this site.
Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? what i saw it RANDOMLY fails (rarely) before this code ---------------------- set_block_property('BLK_CLA_COLUMBO_WORKBUFFER', DEFAULT_WHERE, l_query); ---------------------- It seems sometime the set_block_property is not able to find the database table assigned to this Please type your message and try again. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. 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
Where the select result is more than one row. The time now is 21:16. That error appears. I am using Forms 6i.
i want to display the values for all the above mentioned columns along with dname also. Frm-40505+from Clause Query hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. 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 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
Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Problem in TIBCO BW JDBC Query Receipt Line Duplicate Error in Payables Interface Receipt Routing Reversal Oracle Order Management R12 : Error in Entry Prepayment unable to create a new stored Ora 40505 Unable To Perform Query When i click "Find" button. Frm 40505 Execute Query Kindly respond at the earliest.
and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php i was sorry for not explaining u correctly Like Show 0 Likes(0) Actions 9. For those of you who don't know, SQL injection is the manipulation of field data to trick the application into executing an extra statement. i want to display the values for all the above mentioned columns along with dname also. Frm-40505 Unable To Perform Query 11g
As I suggested to you as sson as you get this error Press Shift+F1. 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. Thanks sheik Like Show 0 Likes(0) Actions 5. check over here Home | Invite Peers | More Oracle Groups Your account is ready.
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) Frm-40508 Please enter a title. To start viewing messages, select the forum that you want to visit from the selection below.
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. Exception when too_many_rows then --put the message here End; Regards, Guru Top This thread has been closed due to inactivity. 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 Frm 40735 But I feel that it is trying to do that when I receive this message in the first block.
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. I'm not sure what we will do, but will hash it out and get back with actions taken. Mitt kontoSökMapsYouTubePlayGmailDriveKalenderGoogle+ÖversättFotonMerDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden http://jamisonsoftware.com/unable-to/frm-40505-oracle-error-unable-perform.php Report message to a moderator Previous Topic: pl/sql looping Next Topic: About Image Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup &
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. 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 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 You will find out the cause of your problem.
Start by running this query outside of Forms, in SQL*Plus!Did you do a "show errors" to see your error?QUOTE FRM-40505: ORACLE error: unable to perform query. All rights reserved. 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: This will open a window with the query which form tried to fire.
Original answer by daniel perlmutter Nov 7, 2012 Contributors: Top You have a select like SELECT A INT0 B FROM C WHERE ?... Re: FRM-40505: unable to perform query 622640 Feb 12, 2008 10:08 AM (in response to Tony Garabedian) Thanks for your reply tony but i need to populate the details for the