problem with lexical parameter [message #339158] |
Wed, 06 August 2008 23:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sara110
Messages: 17 Registered: October 2007
|
Junior Member |
|
|
Hi every one
I have problem with lexical reference
I have select statment as bellow
SELECT DISTINCT A.BRNCD BRNCD1
,A.FUNDCD FUNDCD1
FROM LN01COMMON A, LN01MAST B
WHERE A.BRNCD >= :V_FROMBR
AND A.BRNCD <= :V_TOBR
AND A.BRNCD = B.BRNCD
AND A.MODCD = B.MODCD
AND B.ACSTS IN ('A','R','L','2','V')
&FUND_CD
&BUMI
AS user parameter I have
FUND_CD and BUMI -->lexical parameter
v_fundcd and v_bumi --> user input
ON After parameter trigger
IF :V_BUMI = 'ALL' THEN
:BUMI := '';
ELSE
:BUMI := 'AND GET_OTHDATA.GET_CHAR(B.CIFKEY,''CB'',''BUMI'') ='||''''||:V_BUMI||'''';
END IF;
IF :V_FUNDCD = 'ALL' THEN
:FUNDCD:= '';
ELSE
:FUNDCD:= 'AND A.FUNDCD = '||''''||:V_FUNDCD||'''';
END IF;
the problem is when user enter ALL for V_FUNDCD it dosent show any data on server but at report builder it shows me the data.
I guess IF :V_FUNDCD = 'ALL' THEN has a problem.unlike v_bumi
:FUNDCD:= '';
which i use the same method.
Thanx in advance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: problem with lexical parameter [message #339721 is a reply to message #339718] |
Fri, 08 August 2008 04:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Sara | I have compiled all.Shouldn't I?
|
That's fine. Some people just compile incremental (Ctrl + K), and compiling "all" helps. Sometimes. Not in your case. Unfortunately.
|
|
|