frm-40505 oracle error unable to perform query Shelbyville Texas

Address Nacogdoches, TX 75961
Phone (936) 615-4630
Website Link http://www.hopkinstech.com
Hours

frm-40505 oracle error unable to perform query Shelbyville, Texas

daniel perlmutter replied Nov 7, 2012 Hendracy hi You must check the line number 1743 to see what your are fetching By example if there is more than one receipt in It shows "ORA-00904: invalid column name" and that is correct. rajthampi replied Nov 7, 2012 Unless this is a customized apps form, you shouldn't try to fix it yourself. Always respect the original author.

Home | Invite Peers | More Oracle Groups Your account is ready. and to populate the DNAME value, use the POST-QUERY trigger. Donald K. Where the select result is more than one row.

could any one show the solution for this 45263Views Tags: none (add) This content has been marked as final. Where the select result is more than one row. http://forums.oracle.com/forums/thread.jspa?threadID=616908Or go here:http://blogs.oracle.com/shay/2007/03/02/ 0Votes Share Flag Collapse - Reponse To Answer by john.a.wills ยท 6 years ago In reply to More info to your questio ... Toolbox.com is not affiliated with or endorsed by any company listed at this site.

Toolbox.com is not affiliated with or endorsed by any company listed at this site. Am working in Designer 6i Forms. I would also like to look at the query as the Form has constructed it. You can not post a blank message.

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Thanks in Advance for any helpful suggestions. So I need to take this information to a team member and see what we can do. Set it to "No" it should work.

and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. END; LOG(...) is of course your own standard logging procedure, as I assume you have one. 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 Select forumWindowsMac OsLinuxOtherSmartphonesTabletsSoftwareOpen SourceWeb DevelopmentBrowserMobile AppsHardwareDesktopLaptopsNetworksStoragePeripheralSecurityMalwarePiracyIT EmploymentCloudEmerging TechCommunityTips and TricksSocial EnterpriseSocial NetworkingAppleMicrosoftGoogleAfter HoursPost typeSelect discussion typeGeneral discussionQuestionPraiseRantAlertTipIdeaSubject titleTopic Tags More Select up to 3 tags (1 tag required) CloudPiracySecurityAppleMicrosoftIT EmploymentGoogleOpen SourceMobilitySocial

I am using Forms 6i. If you're able to get the form without any errors then write execute_query in when_new_form_instance. Kindly advise. For example from 01-Oct-2012 to 30-Oct-2012.

I'm not sure what we will do, but will hash it out and get back with actions taken. 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 Thanks, Maggie Reply With Quote 03-16-04,10: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 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:

Anyone with help. So the trin formed will be as follows: 'Where ctry_cd= AND part_nr = ' which is an erroneous string. FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Please remember to be considerate of other members.

Please let us know what your solution will be. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 1:42 PM (in response to 622640) You need to have some sort of relation between the DEPT Block. Re: FRM-40505: unable to perform query 791846 Aug 17, 2010 6:04 AM (in response to 622640) i have an error FRM-40505: unable to perform query want solution plz Like Show 0 Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

The time now is 21:18. 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... Copy the query from the Pop-up window and execute it on SQL prompt. In its bottom part you should be able to scroll through the whole statement that raised an error and compare columns with actual columns in your table.

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 Reply With Quote 03-16-04,11:18 #5 andrewst View Profile View Forum Posts Visit Homepage Moderator. Cause: Processing error encountered. 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)

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. Begin ... ... You can simply press Shift+F1 to see what is the Query your Form builder has fired. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

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 & MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Re: FRM-40505: unable to perform query Tony Garabedian Feb 13, 2008 8:07 AM (in response to 622640) Here is my issue i have two data blocks emp,dept(with the same values in Maybe one of the values passed to your parameters has a single apostrophe embedded in it.

I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... 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 You're now being signed in.

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