Frm 40502 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 with a form with 6iFrm-40502 Solution
release, converted to 10g. In that while clicking F9 for LOV in one of the fields, I unable to read list of values in oracle forms 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 oracle error unable to read list of values 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 ) November ( 4 ) October ( 11 ) September ( 28 ) August ( 8 ) July ( 4 ) June ( 3 ) May ( 12 ) April (
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site
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 http://askanantha-mirror.blogspot.com/2008/04/frm-40502-oracle-error-unable-to-read_3151.html 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 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 unable to 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 unable to read 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 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) Migrati