Frm-40505 Error Oracle
Contents |
to perform query error [message #85200] Wed, 09 June 2004 02:00 amit sharma Messages: 9Registered: ora 40505 unable to perform query October 2002 Junior Member Hi, I am using Oracle
Frm 40505 Execute Query
forms 6i (But it is not deployed on web) I am having a database
Frm-40505 Unable To Perform Query 10g
block which has database items and also certain non-database items. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its
Frm-40505 Unable To Perform Query 11g
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)||''''; 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'); ora-01722: invalid number frm-40505: oracle error: unable to perform query. 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 - "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 blo
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 frm-40505+from clause query UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION frm-40508 GROUP Research 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 frm 40735 maxwellarnold Michael Meyers-Jouan 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 http://www.orafaq.com/forum/t/31910/ Packard Epicor Software ... 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 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 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 u
Member No.: 39,007 Can someone please tell me http://dbaforums.org/oracle/index.php?showtopic=16964 what's wrong with the following? Everytime I try to execute, I get "FRM-40505 Oracle Error: unable to perform query". Thanks so much in advance for your help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE http://en.glufke.net/oracle/viewtopic.php?f=4&t=2552 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 unable to (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 (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 unable to perform 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.: 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,
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site