Parsing Error in SQL Query

[f_chas01]

There is some obvious problem while parsing the sql query.

Parsing this query works perfectly:

select '01.02.$P!{P_YEAR}' txt from dual

But if the parameter is within some certain bracket constallation it does not work, example:

select to_char(last_day(to_date('01.02.$P!{P_YEAR}', 'dd.mm.yyyy')),'DD') txt from dual

$P!{} will not be evaluated. You will get the same error message, as if you would write

select to_char(last_day(to_date('01.02.blablabla', 'dd.mm.yyyy')),'DD') txt from dual

The error is:

Code:

Post Edited by f_chas01 at 06/29/2011 14:35

[f_chas01]

Did someone encountered the same problem?

[Teodor Danciu]

Hi,

 

What version of JR are you using?

 

Thank you,

Teodor

 

[f_chas01]

teodord
Wrote:

Hi,   What version of JR are you using?   Thank you, Teodor

I am using the JasperReport Server 4.1 bundle