Frm-40502 Oracle Error
Contents |
your DBA or an Oracle support representative. Level:>25 Type:Error ---
I had not encountered this error till recent times. But it was today I had encountered this error. I was scratching my head as to what caused this error. I was working unable to read list of values in oracle forms with a form with 6i release, converted to 10g. In that while clicking F9 for LOVOracle Error Unable To Read List Of Values
in one of the fields, I encountered this error. I started debugging the form, starting from Field, LOV, Record Group. There were no problems at first sight. I copied the SQL query from the record group and ran it in SQL*Plus, there was no problems. The query was using some bind variables from inside the form. I had modified these fields with values. I then tried to run exactly the same where clause of the query (I commented out the bind variables) and ran the form. Bingo! It worked and the FRM-4502 error suddenly is gone. I then tried to run the previous query (with bind variables), now also the error did not came. I suppose this error is due to the ID of the field with which Forms works rather than the name. It made a super note for me today... Hope if you are in same mood, use this logic to solve your problem. RegardsAnantha Email This BlogThis! 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 July ( 1 ) May ( 1 ) January ( 1 ) June ( 1 ) May ( 1 ) April ( 1 ) July ( 3 ) June ( 1 ) May ( 3 ) April ( 1 ) January ( 3 ) December ( 1 ) September ( 2 ) August ( 5 ) July ( 1 ) February ( 2 ) January ( 2 ) December ( 1 ) October ( 4 ) September ( 1 ) August ( 1 ) July ( 1 ) November ( 3 ) September ( 2 ) June ( 2 ) March ( 1 ) February ( 1 ) January ( 1 ) October ( 3 ) August ( 2 ) May ( 2 ) April ( 4 ) March ( 1 ) September ( 1 ) July ( 6 ) June ( 5 ) May ( 4 ) April ( 1 ) March ( 2 ) February ( 1 ) January ( 13 ) December ( 7 ) November ( 1 ) October ( 2 ) July ( 6 ) June ( 1 ) May ( 10 ) April ( 4 ) March ( 2 ) February ( 5 ) January ( 3 ) December ( 3 ) Nove
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.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://askanantha.blogspot.com/2008/04/frm-40502-oracle-error-unable-to-read.html VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=FRM-40502 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
11, 2008 / Labels: FRM-Errors This is what Oracle has to say about this error: --- FRM-40502: ORACLE error: unable to read list of values. Cause:A fatal error occurred while trying to read a list of values. Action:Contact your DBA or an Oracle support representative. http://askanantha-mirror.blogspot.com/2008/04/frm-40502-oracle-error-unable-to-read_3151.html Level:>25 Type:Error ---
I had not encountered this error till recent times. But it was today I http://www.orafaq.com/forum/t/127180/ had encountered this error. I was scratching my head as to what caused this error. I was working with a form with 6i release, converted to 10g. In that while clicking F9 for LOV in one of the fields, I encountered this error. I started debugging the form, starting from Field, LOV, Record Group. There were no problems at first sight. I copied the SQL oracle error query from the record group and ran it in SQL*Plus, there was no problems. The query was using some bind variables from inside the form. I had modified these fields with values. I then tried to run exactly the same where clause of the query (I commented out the bind variables) and ran the form. Bingo! It worked and the FRM-4502 error suddenly is gone. I then tried to run the previous query (with bind variables), now also the error did unable to read not came. I suppose this error is due to the ID of the field with which Forms works rather than the name. It made a super note for me today... Hope if you are in same mood, use this logic to solve your problem. RegardsAnantha Newer Post Older Post Home Blog Archive ► 2009 (23) ► June (2) ► May (4) ► April (1) ► March (2) ► February (1) ► January (13) ▼ 2008 (40) ► December (7) ► November (1) ► October (2) ► July (5) ► June (1) ► May (10) ▼ April (4) ORA-06502: PL/SQL: numeric or value error ORA-04031: Unable to allocate %s bytes of shared m... Query to find out queries running in database FRM-40502: ORACLE error: unable to read list of va... ► March (2) ► February (5) ► January (3) ► 2007 (94) ► December (3) ► November (4) ► October (11) ► September (28) ► August (8) ► July (4) ► June (3) ► May (12) ► April (6) ► March (15) ► 2005 (2) ► July (2) Labels 1Z0-001 (1) 1Z0-007 (1) 1Z0-047 (1) 1Z0-051 (1) 1Z0-101 (1) 1Z0-131 (1) 1Z0-132 (1) Application Server (5) Certification (2) Database design (1) DB Administration (8) Deprecated (1) Download (3) Examples (29) Export Utility (1) FAQ (11) Features (7) Forms (8) FRM-Errors (1) HOW-To? (7) JInitiator (2) Migration (2) MS-SQL vs Oracle (1) OCP (1) ORA-Errors (14) Oracle Packages (1) Oracle Universal Installer (1) Oracle X24Registered: July 2008 Junior Member HI i just try to open a lov from my form a have an oracle error FRM-40502.unable to read LOV.i tried to run it from toad it works select FRN.NUM FRN_NUM /* CG$FK */ ,FRN.LIB DSP_LIB2 from NJS_ENTEFRN FRN where CC__FILTRE_SJU('000',FRN.NUM,'FRN')=1; Someone have an idea for this problem. Report message to a moderator Re: LOV [message #357144 is a reply to message #357142] Tue, 04 November 2008 02:47 Littlefoot Messages: 20841Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator This is what Oracle says:Quote:FRM-40502: ORACLE error: unable to read list of values. Cause: A fatal error occurred while trying to read a list of values. Action: Contact your DBA or an Oracle support representative. What happens if you remove commented part out of a query, so that it looks like this: select FRN.NUM FRN_NUM, FRN.LIB DSP_LIB2 from NJS_ENTEFRN FRN where CC__FILTRE_SJU('000', FRN.NUM, 'FRN') = 1; Report message to a moderator Re: LOV [message #357153 is a reply to message #357144] Tue, 04 November 2008 03:05 georges.choueiry Messages: 24Registered: July 2008 Junior Member if i remove the commented part i have the same error; my probleme is from the where condition. but in toad it is working. Report message to a moderator Re: LOV [message #357158 is a reply to message #357153] Tue, 04 November 2008 03:10 Littlefoot Messages: 20841Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator As we don't know what the CC__FILTRE_SJU function does, would it be possible to rewrite it using pure SQL (so that you wouldn't have to use a function in the WHERE clause)? Report message to a moderator Re: LOV [message #357180 is a reply to message #357142] Tue, 04 November 2008 04:06 rajy_salim Messages: 204Registered: January 2008 Location: Beirut - Lebanon Senior Member Georges, Try to create a parameter and assign the return value of the function to this parameter in s