50004-162 error in prepared statement

[Sergey Sachkov]

Hi,

I have error 50004-162 in prepared statement here it is:

update test set user=?, expires=sysdate + ?, name=?,
last_modified=sysdate where test= ?

as I understood error appeares because of expires=sysdate + ?
statment. Are there any way to make it work like it is now?

Thanks in advance,
Regards,
Sergey

[Peter Yuill]

Hi Sergey,

> I have error 50004-162 in prepared statement here it is:
>
> update test set user=?, expires=sysdate + ?, name=?,
> last_modified=sysdate where test= ?
>
> as I understood error appeares because of expires=sysdate + ?
> statment. Are there any way to make it work like it is now?

You could try DATEADD() eg

update test set user=?, expires=DATEADD('DAY', ?, sysdate), name=?,
last_modified=sysdate where test= ?

Regards,
Peter

[Sergey Sachkov]

Hi Peter,

Thank you for your reply.

 I use H2 DB for functional tests, with app that use Oracle DB and JDBC in Java, so it has queries that I wouldn't like to change. For now I did changed the code to calculate the date in java and just put it as parameter. But for the future I think that it would be good to support this behaivour in Oracle mode.

Thanks,
Regards,
Sergey