Home > Unable To > Frm 40505 Error

Frm 40505 Error


rajthampi replied Nov 7, 2012 Unless this is a customized apps form, you shouldn't try to fix it yourself. FRM-40505: ORACLE error: Unable to Perform Query hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... 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 gurujothi replied Nov 7, 2012 Hi Hendracy, As everyone mentioned,Your select ..into should be a reason for this, so check your code, If you know your query could return more than have a peek here

what i saw it RANDOMLY fails (rarely) before this code ---------------------- set_block_property('BLK_CLA_COLUMBO_WORKBUFFER', DEFAULT_WHERE, l_query); ---------------------- It seems sometime the set_block_property is not able to find the database table assigned to this Reset Post Submit Post Software Forums Software · 43,580 discussions Open Source · 248 discussions Web Development · 11,534 discussions Browser · 1,205 discussions Mobile Apps · 47 discussions Latest From After going thru the entire discussion now I can see the exact error message after pressing Shift+F1. Your ON-ERROR trigger should look something like this: PHP Code: DECLARE
Ora 40505 Unable To Perform Query

All rights reserved. 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. Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query?

HTH Regards Himanshu Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158099 is a reply to message #85218] Wed, 08 February 2006 Begin ... ... You can simply press Shift+F1 to see what is the Query your Form builder has fired. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. Maggie Reply With Quote 03-17-04,16:59 #9 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 Well, I said I'd let you know the

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Frm 40505 Execute Query Like Show 0 Likes(0) Actions 4. For those of you who don't know, SQL injection is the manipulation of field data to trick the application into executing an extra statement. Set it to "No" it should work.

Subscribe Entries (RSS) Comments (RSS) Archives December 2011 August 2011 July 2011 May 2011 Categories ERP My entry Oracle Uncategorized Meta Register Log in Create a free website or blog at Frm-40505+from Clause Query Oracle Forms Survey Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. And I might be a very old and mistrusting programmer, but as long as I do not see the l_query in a logfile, I do not believe in the l_query 'you

Frm 40505 Execute Query

You should prevent it from happening in the first place rather than try to hide the fact that it has happened! But I feel that it is trying to do that when I receive this message in the first block. Ora 40505 Unable To Perform Query Re: FRM-40505: unable to perform query 567066 Feb 12, 2008 5:20 PM (in response to Tony Garabedian) Guess what you have to do is assuming ( if I inderstood your issue Frm-40505 Unable To Perform Query 10g Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator.

That error appears. http://blogeurope.net/unable-to/frm-40505-error-de-oracle.php I am using Forms 6i. and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. 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 Frm-40505 Unable To Perform Query 11g

If you need any further info to solve this problem, plz revert. Thanks sheik Like Show 0 Likes(0) Actions 5. Toolbox.com is not affiliated with or endorsed by any company listed at this site. http://blogeurope.net/unable-to/frm-40505-oracle-error.php The SQL Statement in Error is: 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 ) and (PIG_BASIS_ACCOUNTS.PIG_ID=:1)

Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech Frm-40508 But, I am not sure where to effect that change (rectify column name), which is not matching with one of my database table column names. Re: FRM-40505: unable to perform query 622640 Feb 13, 2008 8:32 AM (in response to Tony Garabedian) ok dname was the column i want to execute along with emp columns according

That means that hour where condition is not unique DANI Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Please remember to be considerate of other members. I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. This tool uses JavaScript and much of it will not work correctly without it enabled. Frm 40735 Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158170 is a reply to message #85200] Wed, 08 February 2006 16:19 RJ.Zijlstra Messages:

Also below it you will find another error message like "Invalid column" or "nvalid No" etc. In find receipt menu i only use parameter for "Receipt Dates". All Replies (8) Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... http://blogeurope.net/unable-to/frm-40505-error-oracle.php All product names are trademarks of their respective companies.

Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 What do you see when you select Help - Display Error from the form menu just after you get the 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 by Peconet Tietokoneet · 6 years ago In reply to How do I find an Oracle e ... 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

Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr. Select a Product... Maybe one of the values passed to your parameters has a single apostrophe embedded in it. Everytime I try to execute, I get "FRM-40505 Oracle Error: unable to perform query".

Maybe a developer can help you . . . When i click "Find" button. Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... If this is your first visit, be sure to check out the FAQ by clicking the link above.

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. Reply With Quote 03-16-04,11:18 #5 andrewst View Profile View Forum Posts Visit Homepage Moderator. Thanks in Advance for any helpful suggestions. Thanks much for your help.

Like Show 0 Likes(0) Actions 8. It shows "ORA-00904: invalid column name" and that is correct. LOG( l_query ); Set_property.... ...