Now in Oracle 9i Developer Suite Forms it's a DIFFERENT story. Report message to a moderator Re: ORACLE ERROR Unable to read list of values [message #477224 is a reply to message #477145] Wed, 29 September 2010 09:28 rkgoyal98 Posted on 2005-01-28 Oracle Database 6 1 solution 14,321 Views Last Modified: 2013-12-12 I have a button that has a trigger WHEN-BUTTON-PRESSED which calls the Show_LOV function in Forms that will But in the FORM I get this error. my review here
The FROM clause of the qu... Members Search Help Register Login Home Home» Developer & Programmer» Forms» ORACLE ERROR Unable to read list of values (DB11g, AS10g) Show: Today's Messages :: Show Polls :: Message Navigator E-mail Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerException: Unable to read the list of previously registered servers on this system. Hope if you are in same mood, use this logic to solve your problem. http://askanantha.blogspot.com/2008/04/frm-40502-oracle-error-unable-to-read.html
Join the community of 500,000 technology professionals and ask your questions. If true will display the LOV based on my result set from the query. Recreating the 2 subdirectory and rebooting, everything seems fine.
I was scratching my head as to what caused this error. Join Now For immediate help use Live now! If you look at the sub-query within my query, it's get a MINimum value. The query in the record group is very simple "SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'" All these forms were fine previously when database was on 10g.
Script for getting Oracle table size There is no oracle defined function for getting size of a table. Unable To Read List Of Values In Oracle Forms The query was using some bind variables from inside the form. Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site Bem-vindo: Qui, 08 https://support.microsoft.com/en-us/kb/955648 Share to Twitter Share to Facebook Posted by Anantha Narayanan Labels: FRM-Errors Newer Post Older Post Home Subscribe to: Post Comments ( Atom ) Blog Archive Blog Archive October ( 1
I copied the SQL query from the record group and ran it in SQL*Plus, there was no problems. To re-iterate, this only seems to be an issue when the component is in a Visualforce page and has a lookup field populated. (As an aside, the same thing happens when Frm-40502 Unable To Read List Of Value Not the answer you're looking for? Frm-40502 Solution The variable looks fine in PowerShell, but not in Command Prompt.
It made a super note for me today... this page In that while clicking F9 for LOV in one of the fields, I encountered this error. asked 9 months ago viewed 1055 times active 28 days ago Linked 6 How to pass sobject list to apex from lightning? 2 Why am I unable to pass an Opportunity Strangely enough in one of the form the same list of values is working fine for all the users and i had compared all the properties in lov, record group and
Get Your Free Trial! Problem: FRM-40502: ORACLE error: unable to read list of values. 06-11-2009 11:54 AM Problem: FRM-40502: ORACLE error: unable to read list of values. What do you do with all the bodies? get redirected here Oracle Database Advertise Here 758 members asked questions and received personalized solutions in the past 7 days.
Browse other questions tagged visualforce lightning or ask your own question. Thanks, Gio 0 Comment Question by:jaramill Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/21293187/FRM-40502-ORACLE-error-unable-to-read-list-of-values.htmlcopy Best Solution bymodulo Closed, 500 points refunded. Join & Write a Comment Already a member?
Action: Contact your DBA or an Oracle support representative. Light-bulb moment. An expensive jump with GCC 5.4.0 Why did the humans never use EMP bombs to kill the machines in The Matrix? Lightning Components are shifting sands at the moment, but something I'll be considering in the future.
ORA-06502: PL/SQL: numeric or value error The docs note this on the ORA-06502 error: ORA-06502: PL/SQL: numeric or value error string Cause: An arithmetic, numeric, string, conversio... Is Einstein's theory really challenged by the recent paper in news? Cause:A fatal error occurred while trying to read a list of values. useful reference Follow by Email Labels 10g vs 11g 1Z0-001 1Z0-007 1Z0-047 1Z0-051 1Z0-101 1Z0-131 1Z0-132 AngularJS APEX Application Server Book Review Bug Reports Certification Database design DB Administration Deprecated Download Examples Export
Report message to a moderator Re: ORACLE ERROR Unable to read list of values [message #478675 is a reply to message #477261] Mon, 11 October 2010 21:45 rkgoyal98 Word that includes "food, alcoholic drinks, and non-alcoholic drinks"? Here's my query that the LOV based on the RECORDGROUP would execute: SELECT coy_comment_type_cd, coy_comment_type_desc, coy_comment_order FROM dts_comment_type WHERE coy_group_cd = 'CTR' AND coy_status = 'A' AND coy_comment_order