OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » LOV

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOV [message #357142]

Tue, 04 November 2008 02:42

georges.choueiry
Messages: 24
Registered: 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: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account 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: 24
Registered: 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: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account 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: 204
Registered: 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 some trigger, and use this parameter in the LOV instead of the function.

Rajy

Report message to a moderator