You can print your SQL statement and copy the statement and execute it in SQL. This way you can easily figure out the problem.

Hope the above helps.
Thanks,
Satheesh.