At 01:10 PM 9/03/2007, you wrote:

>Helen,
>
>Thank you for your quick response. This is simple statemenet:
>
>SELECT EMAIL
>FROM XW_EMAIL
>WHERE WID = 3211

Sorry, but I don't believe that is the statement that is being pushed
across the wire. Look at the error message:

> >Token unknown - line 1, char 260

Which says that the statement where the error occurs is longer than
260 characters. You have at most 42 characters in the statement that
you are quoting.

>There is no field called "CHARACTER_LENGTH". The query is running
>fine, except in my java code.
>
>Any other thought?

Well, it's the same thought, actually. Find out the statement that
is getting pushed across the wire when the substitution occurs and
then find out where it is getting that CHARACTER_LENGTH reference
from. Do you have an SQLMonitor tool that you can use to see what
the *actual* statement is that your java code is pushing across?

Helen