All product names are trademarks of their respective companies. Can you help me capture this error/message/alert so that the user will not see it? So I need to take this information to a team member and see what we can do. Thanks much for your help. have a peek here
You may have to register before you can post: click the register link above to proceed. Select a Product... I am using Forms 6i. Thanks much for helping me get this straightened out.
One was a validation at table level and the other... Begin ... ... Reset Post Submit Post Software Forums Software · 43,580 discussions Open Source · 248 discussions Web Development · 11,534 discussions Browser · 1,205 discussions Mobile Apps · 47 discussions Latest From
It shows "ORA-00904: invalid column name" and that is correct. Like Show 0 Likes(0) Actions 10. This will open a window with the query which form tried to fire. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. 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
The time now is 18:41. Frm 40505 Execute Query 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 Subscribe Entries (RSS) Comments (RSS) Archives December 2011 August 2011 July 2011 May 2011 Categories ERP My entry Oracle Uncategorized Meta Register Log in Create a free website or blog at 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
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: Frm-40505+from Clause Query Action: Pressing [Display Error] provides more information, if it is available. Kindly advise. 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
To start viewing messages, select the forum that you want to visit from the selection below. My schema name is G_HRS, Table Name - HRS_MSTEMPLOYEE. Ora 40505 Unable To Perform Query MHE Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158139 is a reply to message #85206] Wed, 08 February 2006 11:24 karan.shandilya Frm-40505 Unable To Perform Query 10g i want to display the values for all the above mentioned columns along with dname also.
I would also like to look at the query as the Form has constructed it. and to populate the DNAME value, use the POST-QUERY trigger. What kind of trigger or other trace can I use? Check This Out Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr.
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 Frm-40508 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 For example from 01-Oct-2012 to 30-Oct-2012.
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 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. hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Frm 40735 Maybe a developer can help you . . .
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 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 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. http://jamisonsoftware.com/unable-to/frm-40505-error-de-oracle.php The validation that was going on in the WHERE clause was also being done in two other places in the form.
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 ... In find receipt menu i only use parameter for "Receipt Dates". For example from 01-Oct-2012 to 30-Oct-2012. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query?
If this is your first visit, be sure to check out the FAQ by clicking the link above. 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 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. Kindly respond at the earliest.
Please remember to be considerate of other members. Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? All rights reserved. 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.
Also below it you will find another error message like "Invalid column" or "nvalid No" etc. So I'm not asking it to query the child when I query the parent. You noticed that this is a DBA forum, right?