|
| Re: Odd error with Reporting Services and Oracle |
 |
Thu, 27 Apr 2006 15:25:43 +000 |
What types are your parameters and what is the SQL you are using in your
DataSet? I've seen this kind of error passing a parameter that is declared as a
string in the report to an oracle parameter that is compared against a Date type
in Oracle.
Mike
|
| Post Reply
|
| Re: Odd error with Reporting Services and Oracle |
 |
Thu, 27 Apr 2006 15:40:17 +000 |
Sorery I meant to post a followup to this. The solution is that SQL RS 2k5
takes a string that happens to be a date and makes it a date without telling.
When it goes into oracle as this "Date" it will go in in the default
SQL date format. So you need to match the format mask in the oracle TO_Date
function call to the 3 letter month sql format.
Interesting, RS 2K did not do this.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|