Problem with values for parameters

Hi,

ich created a report using two report parameters to define a time interval. So far so good. I enter the dates by the pattern 'DDMMYYYY'. The problem is that I get an error when the parameter value for the end date starts with a zero, for example '08012009'. For my surpirce this behavior doesn't appear for the parameter for the beginning date.

The error message is the following:
"Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: ORA-01847: day of month must be between 1 and last day of month"

Does omeone know what to do?

Find more posts tagged with

Comments

bhanley

What data type are you giving your parameter when it is instantiated? Sounds like we need to make sure this is a valid Date type before anything is done with it.

ostrich

It's a string. It will be entered by the user using a html form and inside the query this string will be converted into a date using the to_date function of oracle.

ostrich

Okay, I found my mistake: I forgot the surrounding quotes. So i think the input was interpreded as integer so that the leading zero was deleted...