Frm-40505 Error Unable To Perform Query
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can
Ora 40505 Unable To Perform Query
not post a blank message. Please type your message and try again. More frm 40505 execute query discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Aug 17, 2010 6:55
Frm-40505 Unable To Perform Query 10g
AM by Suhail Faraaz FRM-40505: unable to perform query 622640 Feb 12, 2008 6:26 AM i am having two data blocks Emp,Dept(default tables) i am creating master-detail relationship between two blocks and copying frm-40505 unable to perform query 11g ename into dept. displaying the dept with the feilds of dept table and ename on the canvas exuting query and it is showing error- unable to perform query. could any one show the solution for this 45265Views Tags: none (add) This content has been marked as final. Show 14 replies 1. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 7:51 AM (in oracle error 40505 response to 622640) Just a wild guess regardless what you are trying to do; you have set the "ename" "Databse Item" property to "Yes". That's why the Form is unable to query your table, it's not finding a column called "ename" in the table. Set it to "No" it should work. Tony Like Show 0 Likes(0) Actions 2. 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 field ename also prasad Like Show 0 Likes(0) Actions 3. 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. Which is your master block, EMP or DEPT?? Like Show 0 Likes(0) Actions 4. 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 corretly, else please explain in detail) dept table as master block and emp as detail block on the detail block'
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web
Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query.
Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database frm-40508 Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker
Frm 40735
Ramnath.Awate JoeTorre Locutus Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Service Max Fiberlink Communications Hewlett Packard Epicor Software ... View All Topics https://community.oracle.com/thread/618908 View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Forms A forum where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Forms, including migration, configuration, performance testing, inserting files and records, and displaying reports. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505oracle-errorunable-to-perform-query-3761062 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. 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 Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. FRM-40505:oracle error:unable to perform query stephen_saisi asked Sep 16, 2010 | Replies (4) Am new to oracle forms 10g. Am calling a form from a menu but the when the form loads it returns the error unable to perform query. However when i run the form on its own its able to execute the query. i had put execute_query; in the trigger when_new_block_instance. Anyone with help. Join this group Popular White Paper On This Topic Future Tech: Where will ERP be in 2 Years? 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... rachel ankory replied Sep 16, 2010 nothing in Show Errors ? Top Best Answer 0 Mark this reply as the best answer?
Member No.: 39,007 Can someone please tell me what's wrong with the following? Everytime I http://dbaforums.org/oracle/index.php?showtopic=16964 try to execute, I get "FRM-40505 Oracle Error: unable to perform query". 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 http://en.glufke.net/oracle/viewtopic.php?f=4&t=2552 RORSTAT WHERE RORSTAT_PIDM = RCRAPP1_PIDM AND RORSTAT_AIDY_CODE = RCRAPP1_AIDY_CODE AND RORSTAT_PCKG_COMP_DATE IS NULL AND RORSTAT_PCKG_REQ_COMP_DATE IS NOT NULL)AND (EXISTS (SELECT 'X' FROM ROVAY09 WHERE ROVAY09_PIDM = RCRAPP1_PIDM AND ROVAY09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = unable to RORSTAT_AIDY_CODE AND ROVAY09_APDC_CODE = '52' AND ROVAY09_LEVL_CODE = 'GR')AND (EXISTS (SELECT 'X' FROM ROVAD09 WHERE ROVAD09_PIDM = RCRAPP1_PIDM AND ROVAD09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = RORSTAT_AIDY_CODE AND ROVAD09_LEVL_CODE = 'GR') OR EXISTS (SELECT 'X' FROM ROVST09 WHERE ROVST09_PIDM = RCRAPP1_PIDM AND ROVST09_AIDY_CODE = RCRAPP1_AIDY_CODE AND RCRAPP1_AIDY_CODE = RORSTAT_AIDY_CODE AND ROVST09_LEVL_CODE = 'GR')))) AND RCRAPP1_AIDY_CODE = :AIDY AND RCRAPP1_PIDM =:PIDM burleson View Member Profile Dec 1 2008, unable to perform 01:12 PM Post #2 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi,>> Can someone please tell me what's wrong with the following? You noticed that this is a DBA forum, right? Maybe a developer can help you . . . 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. Cause: Processing error encountered. 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. Action: Pressing [Display Error] provides more information, if it is available. You can also try to update or delete this record later. If necessary, contact your DBA. -------------------- Hope this helps. . . Donald K. 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: Canada Member No.: 881 FRM-40505: ORACLE error: unable to perform query.Cause: Processing error encountered. The table associated with the current block of the form might not exist, or your us
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site