frm oracle error unable to perform query Shawnee Mission Kansas

Address 2421 Burlington St, Kansas City, MO 64116
Phone (816) 786-9117
Website Link
Hours

frm oracle error unable to perform query Shawnee Mission, Kansas

Toolbox.com is not affiliated with or endorsed by any company listed at this site. i want to display the values for all the above mentioned columns along with dname also. Please turn JavaScript back on and reload this page. Maybe a developer can help you . . .

Set it to "No" it should work. But I feel that it is trying to do that when I receive this message in the first block. 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 Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

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 Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years? 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

HTH Regards Himanshu Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85206 is a reply to message #85205] Wed, 09 June 2004 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) You noticed that this is a DBA forum, right? Original answer by daniel perlmutter Nov 7, 2012 Contributors: Top You have a select like SELECT A INT0 B FROM C WHERE ?...

It was not connecting to the database. Select a Product... 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. Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site Home ERP About

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 Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support CommunityOPN Cloud ConnectionOracle Employee CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: 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. Regards Sridhar Rao Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

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 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 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 As I suggested to you as sson as you get this error Press Shift+F1.

and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. 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 Re: FRM-40505: unable to perform query 622640 Feb 12, 2008 10:08 AM (in response to Tony Garabedian) Thanks for your reply tony but i need to populate the details for the 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

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. 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 Like Show 0 Likes(0) Actions 4. I am using Forms 6i.

I'm not sure what we will do, but will hash it out and get back with actions taken. 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 instead create a SR to oracle and let them provide your datafix. 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 &

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. Karan. Maybe one of the values passed to your parameters has a single apostrophe embedded in it. Mitt kontoSökMapsYouTubePlayGmailDriveKalenderGoogle+ÖversättFotonMerDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden

LOG( l_query ); Set_property.... ... Thanks much for helping me get this straightened out. FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Thanks Top This thread has been closed due to inactivity.

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 Like Show 0 Likes(0) Actions 10. In find receipt menu i only use parameter for "Receipt Dates". Kindly advise.

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. It shows "ORA-00904: invalid column name" and that is correct. The point is, that at this moment you have too little information to get the real error cause. 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

could any one show the solution for this 45263Views Tags: none (add) This content has been marked as final. If you need any further info to solve this problem, plz revert. When i click "Find" button. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference kevinsky View Member Profile Dec 2 2008, 09:35 AM Post #3 Advanced Member Group: Members Posts: 37 Joined: 22-October 04 From:

Please enter a title. Top White Papers and Webcasts Popular Taking Business Intelligence to the Next Level Related Forrester Consulting Report: Empowered Customers Drive ... Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Exception when too_many_rows then --put the message here End; Regards, Guru Top This thread has been closed due to inactivity.

Are you passing any parameters to the called form from calling form ? Start a new thread here 3761062 Related Discussions Problem with Execute_Query Problem In Execute_Query execute_query; Executing a query when a tab has focus FRM 40735 - On Error Trigger Raised Unhandled Am working in Designer 6i Forms. Everything looks okay.

Everytime I try to execute, I get "FRM-40505 Oracle Error: unable to perform query". Thanks, Amit Sharma Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85205 is a reply to message #85200] Wed, 09 June 2004 All rights reserved.