Frm-40502 Oracle Error Unable
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search unable to read list of values in oracle forms Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts oracle error unable to read list of values Exchange > Questions > FRM-40502: ORACLE error: unable to read list of values. Want to Advertise Here? Solved FRM-40502: ORACLE error: unable to read list of values. Posted on 2005-01-28 Oracle Database 1 Verified Solution 6 Comments 13,869 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 then return a TRUE or FALSE boolean value. If true will display the LOV based on my result set from the query. If I look at the LOV I see the Record group. I go to the record group and look at the query and everything is fine. I even run the query separately in TOAD and still all the data comes up fine as the same user I'm logged in as. But in the FORM I get this error. Here's the info on this error: Cause: A fatal error occurred while trying to read a list of values. Action: Contact your DBA or an Oracle support representative. Level: >25 Type: Error But nothing is wrong with the database. This is on Oracle 9i Developer Suite Forms connected to an Oracle 9i database on Windows XP. Thanks, Gio 0 Question by:jaramill Facebook Twitter LinkedIn Google Best Solution bymodulo Closed, 500 points refunded. modulo Community Support Moderator Experts Exchange Go to Solution 6 Comments LVL 3 Overall: Level 3 Oracle Database 3 Message Author Comment by:jaramill2005-01-28 Figured it out. Turns out I didn't have privileges set in our security tables even though I could read the query via TOAD. I'll close this question. Gio 0 LVL 3 Overall: Level 3 Oracle Database 3 Message Author Comment by:jaramill2005-01-28 Spoke to soon. It turns out I still can't read it in Oracle 9i Developer Suite. In Oracle 5.0 and 6i I have no problem. Gio 0 LVL 3 Overall: Level 3 Oracle Database 3 Message Author Comment by:jaramill2005-01-28 Okay NOW I found my answer and will like to leave the answer here and then have it closed. 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_com
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. http://askanantha-mirror.blogspot.com/2008/04/frm-40502-oracle-error-unable-to-read_3151.html Cause:A fatal error occurred while trying to read a list of values. Action:Contact 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 6i release, oracle error 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 query from the record group and ran it in SQL*Plus, there was no problems. The query was using some bind variables oracle error unable 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 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: ORAC