Problem while reading fields

[2002 JI Open Discussion]

By: T.Gopalakrishnan - tgopal

Problem while reading fields

2003-11-12 02:57

He is the query I used in the 'Report Query' to read fields.it works fine

 

SELECT CLOSING_BALANCE

FROM CURRENCIES T ,CURRENCY_STOCKS

WHERE (T.NAME=CURRENCY_STOCKS.CURR_NAME(+))

AND NVL(CURRENCY_STOCKS.STOCK_DATE,SYSDATE)=

(SELECT NVL(MAX(STOCK_DATE),SYSDATE) FROM CURRENCY_STOCKS

WHERE CURR_NAME = T.NAME

AND STOCK_DATE<=SYSDATE )

 

But I need to use an parameter value instead of the 'SYSDATE'.so I created an parameter field called 'SDATE' and I changed the query as following and I tried to read fields with the follwing query it throws an SQL exception due to that SDATE(parameter value)

 

SELECT CLOSING_BALANCE

FROM CURRENCIES T ,CURRENCY_STOCKS

WHERE (T.NAME=CURRENCY_STOCKS.CURR_NAME(+))

AND NVL(CURRENCY_STOCKS.STOCK_DATE,$P{SDATE})=

(SELECT NVL(MAX(STOCK_DATE),$P{SDATE}) FROM CURRENCY_STOCKS

WHERE CURR_NAME = T.NAME

AND STOCK_DATE<=$P{SDATE} )

 

 

Can any one help how to resolve this

 

Thanks and Regards

T.Gopalakrishnan