is there a max length for a prepared statement

Hi,

I am trying to pass a SQL statement to an oracle database using the connection.prepareStatement. It is a fairly long string (many single row functions and a union). I am getting an error message ora 908 missing null keyword.

There is no missing null keyword and the select works in sqlplus. So I think that the string is getting truncated right at the point where the query says" and id is". losing the word null

So the question is is there a length restriction and if so how long is it?

Thanks.

[538 byte] By [WandererT] at [2007-9-26 12:09:35]