Oracle Error 40505 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 ora 40505 unable to perform query (But it is not deployed on web) I am having a
Frm-40505 Unable To Perform Query 10g
database block which has database items and also certain non-database items. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am frm 40505 execute query 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 - ----------------------- DECLARE l_query varchar2(200);
Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query.
BEGIN l_query := 'ctry_cd = '||''''||RTrim(form_global.ctry_cd)||''''; 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 frm-40505+from clause query this database block (i.e querying the source Table) ------------------ 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 repl
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
Frm-40508
Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP
Frm 40735
Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold ora-00904 Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus 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 http://www.orafaq.com/forum/t/31910/ 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 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505oracle-errorunable-to-perform-query-3761062 signed in. Solve problems - It's Free Create your account in 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 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 ERP Solutions: Winners and Losers 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 ? To
comment TagsFRM-40505, unable to perform query error May http://en.glufke.net/oracle/viewtopic.php?f=4&t=2552 be there are something wrong with datatype, Try to re-run Datablock Wizard ^^ good unable to luck Hutavi, Share this:TwitterFacebookLike this:Like Loading... Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click unable to perform 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 commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. 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:
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site