Error 40505 Oracle
Contents |
to perform query error [message #85200] Wed, 09 June 2004 02:00 amit sharma Messages: 9Registered: October 2002 Junior Member Hi, I am using Oracle forms 6i (But it ora 40505 unable to perform query is not deployed on web) I am having a database block which has
Frm 40505 Execute Query
database items and also certain non-database items. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically frm-40505 unable to perform query 10g by setting its WHERE clause at the Block level by using following code in PRE-QUERY trigger of the block BLK_CLA_COLUMBO_WORKBUFFER - ----------------------- DECLARE l_query varchar2(200); BEGIN l_query := 'ctry_cd = '||''''||RTrim(form_global.ctry_cd)||''''; ora-01722: invalid number frm-40505: oracle error: unable to perform query. l_query := l_query||' AND part_nr = '||''''||rtrim(form_global.part_nr)||''''; set_block_property('BLK_CLA_COLUMBO_WORKBUFFER', DEFAULT_WHERE, l_query); EXCEPTION WHEN OTHERS THEN show_error('Cannot query the Columbo WB:- PROC_GET_COLUMBO_WB'); END; ------------------------ The PROBLEM i am facing is - sometimes we get a RANDOM error 'FRM-40505- Unable to perform query' while querying this block The code that gets fired for querying data from this database block (i.e querying the source Table)
Frm-40505+from Clause Query
------------------ go_block('BLK_CLA_COLUMBO_WORKBUFFER'); execute_query; ----------------- I looked for the description in form builder help, it says - The 'FRM-40505: ORACLE error: unable to perform query' error has following description - "Processing error encountered. 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 query for the SAME DATA AGAIN in the same session on this block then same code is fired again i.e ------------------ go_block('BLK_CLA_COLUMBO_WORKBUFFER'); execute_query; ----------------- But this TIME it QUERIES the table successfully and populates the data block properly. There is no access priveleges issue with this table. Kindly let me know why this is happening ??? Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? Kindly respond at the earliest. Thanks, Amit Sharma Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85205 is a reply to message #85200] Wed, 09 June 2004 03:56 Himanshu Messages: 457Registered: December 2001 Senior Member
United States Australia United Kingdom Japan Newsletters Forums Resource Library Tech Pro Free Trial Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic Search GO Topics: CXO Cloud frm-40508 Big Data Security Innovation Software Data Centers Networking Startups Tech & Work All Topics ora-00904 invalid identifier Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro Free Trial Editions: US United States Australia United Kingdom Japan
Ora-00942
Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic | Forums | Web Development Web Development Register Now or Log In to post Welcome back, My Profile Log http://www.orafaq.com/forum/t/31910/ Out Recent Activity FAQs Guidelines Question 0 Votes Locked How do I find an Oracle error when I get FRM-40505 in an Oracle Form? By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form. I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. I would http://www.techrepublic.com/forums/discussions/how-do-i-find-an-oracle-error-when-i-get-frm-40505-in-an-oracle-form/ 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. I would also like to look at the query as the Form has constructed it. What kind of trigger or other trace can I use? Share Flag This conversation is currently closed to new comments. 4 total posts (Page 1 of 1) + Follow this Discussion · | Thread display: Collapse - | Expand + All Answers Collapse - More info to your question here.... by Peconet Tietokoneet · 6 years ago In reply to How do I find an Oracle e ... 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 ... Niether of those references leads anywhere useful. 0Votes Share Flag Collapse - Help/Display Error in Sungard's Banner INB, by john.a.wills · 6 years ago In reply to How do I find an Oracle e ... and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. This solves the problem I set, although after some investigation I may b
Member No.: 39,007 Can someone please tell me what's wrong with the following? Everytime I try to execute, I get http://dbaforums.org/oracle/index.php?showtopic=16964 "FRM-40505 Oracle Error: unable to perform query". Thanks so much in advance for your http://www.dbforums.com/showthread.php?988718-How-do-I-capture-FRM-40505-when-executing-query help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE RCRAPP1_INFC_CODE IN ('ISIR','EDE')AND RCRAPP1_CURR_REC_IND = 'Y'AND (EXISTS (SELECT 'X' FROM RORSTAT WHERE RORSTAT_PIDM = RCRAPP1_PIDM AND RORSTAT_AIDY_CODE = RCRAPP1_AIDY_CODE AND RORSTAT_PCKG_COMP_DATE IS NULL AND RORSTAT_PCKG_REQ_COMP_DATE IS NOT NULL)AND (EXISTS (SELECT 'X' FROM ROVAY09 WHERE ROVAY09_PIDM = RCRAPP1_PIDM AND ROVAY09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = RORSTAT_AIDY_CODE AND ROVAY09_APDC_CODE = '52' AND ROVAY09_LEVL_CODE = 'GR')AND (EXISTS unable to (SELECT 'X' FROM ROVAD09 WHERE ROVAD09_PIDM = RCRAPP1_PIDM AND ROVAD09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = RORSTAT_AIDY_CODE AND ROVAD09_LEVL_CODE = 'GR') OR EXISTS (SELECT 'X' FROM ROVST09 WHERE ROVST09_PIDM = RCRAPP1_PIDM AND ROVST09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = RORSTAT_AIDY_CODE AND ROVST09_LEVL_CODE = 'GR')))) AND RCRAPP1_AIDY_CODE = :AIDY AND RCRAPP1_PIDM =:PIDM burleson View Member Profile Dec 1 2008, 01:12 PM Post #2 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: unable to perform 13 Hi,>> Can someone please tell me what's wrong with the following? You noticed that this is a DBA forum, right? Maybe a developer can help you . . . 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. Cause: Processing error encountered. 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. Action: Pressing [Display Error] provides more information, if it is available. You can also try to update or delete this record later. If necessary, contact your DBA. -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference kevinsky View Member Profile Dec 2 2008, 09:35 AM Post #3 Advanced Member Group: Members Posts: 37 Joined: 22-October 04 From: Canada Member No.: 881 FRM-40505: ORACLE error: unable to perform query.Cause: Processing error encountered. 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. Check your SQl, as suggested already, by running this as an SQL statement.Check you have qualified the table
first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query? 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 View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 Unanswered: How do I capture FRM-40505 when executing query? Am working in Designer 6i Forms. After entering a Query, then pressing F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform query. 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. But, have had no luck. Can you help me capture this error/message/alert so that the user will not see it? 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 Provided Answers: 1 Does the query succeed when run from SQL*Plus as the same user who is running the form? Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator. Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Re: How do I capture FRM-40505 when executing query? Your ON-ERROR trigger should look something like this: PHP Code: DECLARE
v_errorNUMBER:=ERROR_CODE;