"Access or violation" error using timestamp with OracleTag(s): Common problems

Using the ODBC escape sequence {ts to represent a timestamp value, you may receive the error "Access violation" if your query looks like 
{ ts '2003-03-25 00:00:00' }
With Oracle, you have to add the milliseconds part. So use this instead 
{ ts '2003-03-25 00:00:00.000000' }

If you find this article useful, consider making a small donation
to show your support for this Web site and its content.

Written and compiled by Réal Gagnon ©1998-2012
[ home ]