Monday, March 12, 2012

Oracle Syntax Error.

Hi,

I have a Oracle query which runs fine at Oracle side(through TOAD or Oracle Client).

I am using sysdate+1 in my query to get the next date.

Now I am using same query in RS using Oracle Client which returns error "ORA-00932:Inconsistent datatypes.Expected DATE got NUMBER".

Basically the driver is unable to interpret to add 1(Number) to the Sysdate(Date) field.

Any suggestions/ideas are greatly appreciated.

Thanks !!

Maybe in your query you should do an explicit CONVERT back to date on the sysdate + 1 expression? I think you may be relying on an implicit conversion which is not happening in this case.

No comments:

Post a Comment