Home > Unable To > Frm Oracle Error Unable To Perform Query

Frm Oracle Error Unable To Perform Query

Contents

I have tried coding the Application Logic Events for ON-ERROR and ON-MESSAGE at the form level and module component level to capture this. Fill in your details below or click 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 Join this group Popular White Paper On This Topic 10 Critical Questions to ask a Manufacturing ERP Vendor 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this Mitt kontoSökMapsYouTubePlayGmailDriveKalenderGoogle+ÖversättFotonMerDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden http://blogeurope.net/unable-to/frm-40505-oracle-error-unable-to-perform-query.php

In find receipt menu i only use parameter for "Receipt Dates". i want to display the values for all the above mentioned columns along with dname also. Kindly respond at the earliest. MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Ora 40505 Unable To Perform Query

Set it to "No" it should work. Where the select result is more than one row. One was a validation at table level and the other... 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

Buy/Market/Sell/Service Smarter eBook Avoiding the Shoebox: Managing Expenses in Small and ... instead create a SR to oracle and let them provide your datafix. Cause: Processing error encountered. Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query. As I suggested to you as sson as you get this error Press Shift+F1.

Your ON-ERROR trigger should look something like this: PHP Code: DECLARE
v_errorNUMBER:=ERROR_CODE;
Frm-40505 Unable To Perform Query 10g

hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Maggie Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft Ora 40505 Unable To Perform Query You're now being signed in. Frm 40505 Execute Query There is no access priveleges issue with this table.

All rights reserved. http://blogeurope.net/unable-to/frm-40505-oracle-error.php I do not know what could be wrong in the parent/child relationship between the tables or blocks. Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? It was not connecting to the database. Frm-40505 Unable To Perform Query 11g

MHE Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158139 is a reply to message #85206] Wed, 08 February 2006 11:24 karan.shandilya As Himanshu already suggested, it could be that in some cases it would be something like '... = '; (A NULL value after one of the = signs) I would strongly For example from 01-Oct-2012 to 30-Oct-2012. Check This Out 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.

Please let us know what your solution will be. Frm-40508 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. Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr.

Re: FRM-40505: unable to perform query Tony Garabedian Feb 15, 2008 7:26 AM (in response to 622640) Thanks for your reply tony but i need to populate the details for the

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... 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 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. Frm 40735 That error appears.

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 All product names are trademarks of their respective companies. Thanks in Advance for any helpful suggestions. this contact form 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

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. i have tried as you told but it is not exucuting the value for dname.if i keep dname as non database item.it is only executing the columns for empYou're talking about All rights reserved. prasadhoney07 replied Nov 7, 2012 Check your procedure APPS.ARP_MISC_CASH_DIST line 1743,there select query returns more than one rows so only you got that error Top Best Answer 0 Mark this reply

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 Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... So the trin formed will be as follows: 'Where ctry_cd= AND part_nr = ' which is an erroneous string. Exception when too_many_rows then --put the message here End; Regards, Guru Top This thread has been closed due to inactivity.

Anyone with help. Home | Invite Peers | More Oracle Groups Your account is ready. Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218631 is a reply to message #158193] Fri, 09 February 2007 01:23 [email protected] Messages: and to populate the DNAME value, use the POST-QUERY trigger.

Select a Product... That error appears. hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM

FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g.