Home » Developer & Programmer » Forms » LOV
LOV [message #357142] Tue, 04 November 2008 02:42 Go to next message
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.
Re: LOV [message #357144 is a reply to message #357142] Tue, 04 November 2008 02:47 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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;
Re: LOV [message #357153 is a reply to message #357144] Tue, 04 November 2008 03:05 Go to previous messageGo to next message
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.
Re: LOV [message #357158 is a reply to message #357153] Tue, 04 November 2008 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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)?
Re: LOV [message #357180 is a reply to message #357142] Tue, 04 November 2008 04:06 Go to previous messageGo to next message
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
Re: LOV [message #357206 is a reply to message #357180] Tue, 04 November 2008 05:05 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/3958/0/ Good idea!
Re: LOV [message #357551 is a reply to message #357153] Wed, 05 November 2008 18:23 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What pragmas do you have on the function?

David
Previous Topic: Time In & Out
Next Topic: problem when call form to another form update collumn
Goto Forum:
  


Current Time: Sat Dec 03 06:08:26 CST 2016

Total time taken to generate the page: 0.18523 seconds