Oracle Error Frm 40505
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 Execute Query
certain non-database items. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its WHERE clause at frm-40505 unable to perform query 10g 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
Frm-40505+from Clause 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 be
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 Development Windows ora-01722: invalid number frm-40505: oracle error: unable to perform query. < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security frm-40508 Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus
Frm 40735
Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle http://www.orafaq.com/forum/t/31910/ 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 seconds E-mail address is taken If this is your http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505oracle-errorunable-to-perform-query-3761062 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 stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Am calling a form from a menu but the when the form loads it returns the error unable to perform query. However when i run the form on its own its able to execute the query. i had put execute_query; in the trigger when_new_block_instance. Anyone with help. Join this group Popular White Paper On This Topic Big Data and the CMO: An Introduction to the Challenge and the Opportunity 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... rachel ankory replied Sep 16, 2010 nothing in Show Errors ? Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... siddarath replied Sep 16, 2010 Please compile the form Top Best Answer
GoogleВойтиСкрытые поляПоиск групп или сообщений