Words flow, and are hardly can be absorbed. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. 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 Like Show 0 Likes(0) Actions 5. Check This Out
You will find out the cause of your problem. Maybe that causes the issue. PCMag Digital Group AdChoices unused HelpInfo Want to narrow your search? Level:>25 Type:Error Please mark as sloved if it helps KK Like Show 0 Likes(0) Actions 4.
SELECT ROWID, PIG_BASIS_ACCOUNTS.FY, PIG_BASIS_ACCOUNTS.ACCOUNT, PIG_BASIS_ACCOUNTS.ID, PIG_BASIS_ACCOUNTS.PIG_ID, PIG_BASIS_ACCOUNTS.CREATE_DATE, PIG_BASIS_ACCOUNTS.CREATED_BY FROM PIG_BASIS_ACCOUNTS PIG_BASIS_ACCOUNTS WHERE ( SELECT PIG_BASIS_ACCOUNTS.ACCOUNT FROM BASIS_ACCOUNTS_VW, PIG_BASIS_ACCOUNTS WHERE BASIS_ACCOUNTS_VW.FY = PIG_BASIS_ACCOUNTS.FY ) > 100 and (PIG_BASIS_ACCOUNTS.PIG_ID=:1) Tony Andrews http://tinyurl.com/tonyandrews Reply More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Jul 15, 2009 1:40 PM by 49905 FRM-40505 452491 Jul 10, 2009 7:08 PM Hi, Amit Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85218 is a reply to message #85206] Wed, 09 June 2004 22:56 Himanshu Action:Pressing [Display Error] provides more information, if it is available.
It would be helpful if you downloaded my ZDebug form, which writes debugging messages you create into a record group, so you can then view the results of your debugging process 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. Register Help Remember Me? Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Re: FRM-40505 49905 Jul 15, 2009 1:40 PM (in response to user346369) Steve, it is obvious, you know much more details about this issue than I do, but after reading the
I would like to see the ORA error number and message, but when i install an On-Error trigger routine for this purpose I get ORA-00000 operation successful, which cannot be right. Frm-40505 Unable To Perform Query 10g After finding the existing record I want in the parent table (first block) I go to the child table (second block) and then select a child that I want to be Re: FRM-40505 user346369 Jul 14, 2009 10:57 PM (in response to 452491) Malik has been emailing me on this problem as well. http://www.helpinfo.com/index.jsp?k2dockey=1021033095251925207&T1=%20%20&titlestring=null&T2=null&taxlevelValue=null&isbrowse=false&taxlevel=null&typeofsearch=null&LastQuery=null&T3=..&T4=null&startat=1&Curr 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." My question is
Thanks so much in advance for your help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE 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 Frm-40508 Where the select result is more than one row. Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation And there is no way I could help with a phone call.
Toolbox.com is not affiliated with or endorsed by any company listed at this site. For example from 01-Oct-2012 to 30-Oct-2012. Ora 40505 Unable To Perform Query You should prevent it from happening in the first place rather than try to hide the fact that it has happened! Frm 40505 Execute Query Just exit_form or may be you use some call/new/open again?
Re: FRM-40505 user346369 Jul 15, 2009 4:28 PM (in response to user346369) I got your answer that there is no problems with :System.message_level or Exceptions. his comment is here IF so, try displaying that. FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic ERP Implementation Strategies All Replies (8) Best Answer 0 Mark this reply as the best answer?(Choose carefully, Frm-40505 Unable To Perform Query 11g
You're making the assumption that both form_global.ctry_cd and form_global.part_nr are never NULL. (And never in 'programming-time' sometimes is remarkebly short...) The saying 'it works when I put it in sql*plus' doesn't The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am 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 Thanks, Maggie Reply With Quote 03-16-04,11: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 this contact form Thanks much for helping me get this straightened out.
Can you share the code in the query procedure that block based on? Frm-40735 i.e begin ...... ....... Kindly advise.
where is the database alert.log located? The variable form_global.part_nr & form_global.ctry_cd are never Null because i assign them before firing query over this erroroneous block and i debugged the query, it always hold the string with ctry_cd CALL_FORM, NEW_FORM, OPEN_FORM (session/no_session) and how do you exit from forms? Ora-00942 Cause:Processing error encountered.
I suspect any "select count(*)" in WNFI will fail too. By john.a.wills · 6 years ago I am getting FRM-40505 unable to execute query in running an Oracle Form. Reset Post Submit Post Software Forums Software · 43,589 discussions Open Source · 249 discussions Web Development · 11,543 discussions Browser · 1,205 discussions Mobile Apps · 47 discussions Latest From navigate here In find receipt menu i only use parameter for "Receipt Dates".
But I feel that it is trying to do that when I receive this message in the first block. Manoj. - I've a GO_BLOCK before EXECUTE_QUERY Thank you all Like Show 0 Likes(0) Actions 7. If this is your first visit, be sure to check out the FAQ by clicking the link above. Report message to a moderator Previous Topic: pl/sql looping Next Topic: About Image Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup &
That error appears. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Check your SQl, as suggested already, by running this as an SQL statement.Check you have qualified the table names with the schema owner or have a synonym for tables in different After going thru the entire discussion now I can see the exact error message after pressing Shift+F1.
Donald K. Copy the query from the Pop-up window and execute it on SQL prompt. Re: FRM-40505 403877 Jul 14, 2009 12:26 PM (in response to 452491) check the datatype of columns in the table and items in the form is matching. Re: FRM-40505 403877 Jul 13, 2009 12:15 PM (in response to 452491) FRM-40505: ORACLE error: unable to perform query.