40505 Oracle Error
Contents |
to friend FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398268] Wed, 15 April 2009 17:14 s.vishalkumar@gmail.com Messages: 22Registered: July 2007
Frm-40505 Oracle Error Unable To Perform Query
Junior Member Hello Everyone!! I have block in which I choose 'From Clause ora 40505 unable to perform query Query' in the property pallete and pasted this query. -------------------- select unique product_type PRODUCT_TYPE from product where supplier_id = :b00.SUPP_VAL
Frm-40505 Unable To Perform Query 10g
and product_gl_class_cd = :b00.gl_class and product_brand = :b00.prod_brand and product_legal_name = :B00.pln order by 1 -------------------------- It works fine when I hardcode the values to it, but when I dynamically want to do, frm 40505 execute query it throws me the following errors: FRM 40505: ORACLE Error: Unable to perform Query and when I press SHIFT + CTRL+E for errors it displays the following: ORA-22806: not an object or REF and the code which it shows is above. Anyone who is aware of such kind of issues please help me out urgently. Thanks, Vishal Report message to a moderator Help unable to perform query in oracle forms reqd. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398531 is a reply to message #398268] Thu, 16 April 2009 10:16 s.vishalkumar@gmail.com Messages: 22Registered: July 2007 Junior Member Is there anyone who could kindly help me out Please!! Report message to a moderator Re: Help reqd. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398598 is a reply to message #398531] Thu, 16 April 2009 20:59 djmartin Messages: 10180Registered: March 2005 Location: Canberra ACT Australia Senior MemberAccount Moderator What happens if you do not use the 'unique'? Please post the table structure. David Report message to a moderator Re: Help reqd. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398607 is a reply to message #398598] Thu, 16 April 2009 22:22 s.vishalkumar@gmail.com Messages: 22Registered: July 2007 Junior Member Hi Martin!! The form is something like this:(in a hierarchical manner) I have a Supplier ID : beside it I have a choose button, which when chosen gives a LOV.I can choose some value Next I have G
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle
Ora-01722: Invalid Number Frm-40505: Oracle Error: Unable To Perform Query.
PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage frm-40508 UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS
Ora-00904 Invalid Identifier
Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Richard JoeTorre bracke Ramnath.Awate http://www.orafaq.com/forum/t/143678/ DukeGanote Locutus Nikki Klein Dennis Stevenson AbhaiTripathi Craig Borysowich Clinton Jones bluesguyAZ59 iudithm mircea_luca Adrian_Grigoriu blrvenkat COMPANIES CloudLock Trend Micro Incorporated Citrix Panaya Inc. 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/frm40505-oracle-error-unable-to-perform-query-4998634 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 - 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 er
Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems unable to Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw unable to perform Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service