Frm Oracle Error Unable To Perform Query
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 is not deployed on ora 40505 unable to perform query web) I am having a database block which has database items and also
Frm-40505 Unable To Perform Query 10g
certain non-database items. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its WHERE clause frm 40505 execute query 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)||''''; l_query := l_query||' AND part_nr = '||''''||rtrim(form_global.part_nr)||''''; frm-40505 unable to perform query 11g 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) ------------------ go_block('BLK_CLA_COLUMBO_WORKBUFFER'); execute_query; ----------------- I looked for the description in form
Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query.
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 Hi, From where your variable form_global.part_nr & form_global.ctry_cd. It seems that at first execution they are null. So the trin formed will
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and frm-40505+from clause query Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking frm-40508 SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus
Frm 40735
Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Service Max Fiberlink Communications Hewlett Packard Epicor Software ... View All Topics View All Members View http://www.orafaq.com/forum/t/31910/ All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Forms, including migration, configuration, performance testing, inserting files and records, and displaying reports. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. 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 Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... i have problem when i revers receipt in receipt batch after that i got message error like this: FRM-40505: ORACLE error: unable to perform query. 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 select like SELECT A INT0 B FROM C WHERE ?.. Where the select result is more than one row. 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. Always respect the original author. Edits are subject to review by community mode
first visit, be sure to check out the FAQ by clicking the link above. You may have to register http://www.dbforums.com/showthread.php?988718-How-do-I-capture-FRM-40505-when-executing-query 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 unable to 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 unable to perform 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;
v_typeVARCHAR