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 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. and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. i.e begin ...... ....... http://blogeurope.net/unable-to/frm-40505-error-de-oracle.php
Action: Pressing [Display Error] provides more information, if it is available. Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation 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 & 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...
Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Top 5 Reasons ERP Installs Fail and What You Can Do About Them All Replies (8) Best For example from 01-Oct-2012 to 30-Oct-2012. 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 Is it a known problem in Oracle forms 6i which can be solved by use of any patch ?
So the trin formed will be as follows: 'Where ctry_cd= AND part_nr = ' which is an erroneous string. By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form. 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 Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Am working in Designer 6i Forms.
To start viewing messages, select the forum that you want to visit from the selection below. Frm 40505 Execute Query Home | Invite Peers | More Oracle Groups Your account is ready. 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. I can go into the Database and see that the correct relationship exists.
I would like to see the ORA error number and message, but when i install an On-Error trigger routine for this purpose I get ORA-00000 operation successful, which cannot be right. Frm-40505+from Clause Query Set it to "No" it should work. EXCEPTION when others then LOG( l_query ); ... Copy the query from the Pop-up window and execute it on SQL prompt.
So I'm not asking it to query the child when I query the parent. 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. Ora 40505 Unable To Perform Query i want to display the values for all the above mentioned columns along with dname also. Frm-40505 Unable To Perform Query 10g 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
Like Show 0 Likes(0) Actions 4. http://blogeurope.net/unable-to/frm-40505-oracle-error-unable-to-perform-query.php 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 All rights reserved. Begin ... ... Frm-40505 Unable To Perform Query 11g
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 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 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: http://blogeurope.net/unable-to/frm-40505-error-oracle.php 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
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 Frm-40508 Share Flag This conversation is currently closed to new comments. 4 total posts (Page 1 of 1) + Follow this Discussion · | Thread display: Collapse - | Expand + No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers
As Himanshu already suggested, it could be that in some cases it would be something like '... = '; (A NULL value after one of the = signs) I would strongly 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 When i click "Find" button. Frm 40735 I do not know what could be wrong in the parent/child relationship between the tables or blocks.
Everything looks okay. MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... I'm not sure what we will do, but will hash it out and get back with actions taken. this contact form One was a validation at table level and the other...
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 Like Show 0 Likes(0) Actions 8. and to populate the DNAME value, use the POST-QUERY trigger. 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
My schema name is G_HRS, Table Name - HRS_MSTEMPLOYEE. Can you help me capture this error/message/alert so that the user will not see it? 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 As I suggested to you as sson as you get this error Press Shift+F1.
Please remember to be considerate of other members. The problem was with the code you, Tony, identified. It shows "ORA-00904: invalid column name" and that is correct. HelpInfo Want to narrow your search?
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. You will find out the cause of your problem. rajthampi replied Nov 7, 2012 Unless this is a customized apps form, you shouldn't try to fix it yourself. Donald K.