Frm-40505 Oracle Error
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 web) I am having a database ora 40505 unable to perform query block which has database items and also certain non-database items. The block name is
Frm 40505 Execute Query
-BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its WHERE clause at the Block level by using following code in frm-40505 unable to perform query 10g 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)||''''; set_block_property('BLK_CLA_COLUMBO_WORKBUFFER', DEFAULT_WHERE, l_query); EXCEPTION WHEN OTHERS THEN show_error('Cannot query the Columbo WB:-
Frm-40505 Unable To Perform Query 11g
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 builder help, it says - The 'FRM-40505: ORACLE error: unable to perform query' error has following description - ora-01722: invalid number frm-40505: oracle error: unable to perform query. "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 as follows: 'Where ctry_cd= AND part_nr = ' which is an erroneous string. You can simply press Shift+F1 to see what is the Query your Form builder has fired. HTH Regards Himanshu Report message
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
Frm-40505+from Clause Query
Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research
Frm-40508
Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan frm 40735 TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus 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 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 being 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 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 error
Visio Microsoft http://en.glufke.net/oracle/viewtopic.php?f=4&t=2552 Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems unable to Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw unable to perform Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site