Frm-40505 Error De Oracle
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 Unable To Perform Query 10g
discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Aug 17, 2010 6:55 AM frm 40505 execute query 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 ora-01722: invalid number frm-40505: oracle error: unable to perform query. 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 45263Views 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 response
Frm-40505+from Clause Query
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's empno field/item
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio frm-40508 Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and frm 40735 Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design
Ora-00904
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 Ramnath.Awate JoeTorre Locutus Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm https://community.oracle.com/thread/618908 AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Service Max Fiberlink Communications Hewlett Packard Epicor Software ... View All Topics 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, http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 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 - 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 hendracy asked Nov 7, 2012 | Replies (8) Dear Guru Please help me... 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. 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
ASP PHP HTML CSS Javascript Aplicaciones prefabricadas BASES DE DATOS SQL Mongo DB Oracle MySQL SQL Server PROGRAMACIÓN APPs Android iOS WindowsPhone BlackBerry Tutoriales http://programacion.net/foros/oracle/frm40505_291798 (current) PROGRAMACIÓN GENERAL C / C++ / C# Java Visual Basic Objective-C Python Perl Ruby Delphi PROGRAMACIÓN WEB ASP PHP HTML CSS Javascript Aplicaciones http://frmcode.ora11g.de/frm-40358-frm-40655/frm-40505.html prefabricadas BASES DE DATOS SQL Mongo DB Oracle MySQL SQL Server PROGRAMACIÓN APPs Android iOS WindowsPhone BlackBerry Noticias Foros Eventos Empleo Inicio Foros Foros de unable to Oracle FRM-40505 × Conéctate a Programacion.net Conectarme a Programacion.net ¿Olvidaste tu contraseña? FRM-40505 Responder Arantxa 22 de Marzo del 2006 Estoy haciendo una proyecto de un videoclub y a la hora de eliminar una pelicula me salta el error frm-40505 pero me borra la pelicula. ¿Como puedo hacer para que unable to perform no me salga ese error? Rodolfo Reyes 22 de Marzo del 2006 La descripción del error dice: 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. Algo así como que estas utilizando una tabla, procedimiento, funcion, etc. que no existe o el usuario con el cual estas ejecutando el proceso no tiene permiso de ver este objeto. Si la versión de Developer es 6i o inferior y estas en cliente servidor, cuando te da el error oprime SHIFT+F1 con esto es probable que te despliegue una mejor descripción del error. Responder NUESTRAS REDES ¿TE HA GUSTADO? INDíCANOSLO Secciones Artículos Tutoriales y código fuente Foros Eventos Empleo Lenguajes Destacados PHP Java ASP Bases de datos C Información Datos Legales Política de privacidad Publicidad Contacto Contacte con nosotros Publicidad Dise&
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.Level: 99 Trigger: ON-ERROR Discussions and Solutions for FRM-40505: ORACLE error: unable to perform query. Oracle Forms Books FRM-40505: ORACLE error: unable to perform query. Record: 1/1 Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners Oracle: Registered trademark of Oracle