Try this.. (as a workaround)
<statement ...>
SELECT /*+ RULE +*/
id, name, email
from ...
</statement>
2005/11/9, Guido García Bernardo <[EMAIL PROTECTED]>:
> Hi,
>
> I'm using ibatis sql maps 2.1.5 + Oracle 8, defining the following query
> statement:
>
> <statement ...>
> SELECT --+RULE
> id, name, email
> from ...
> </statement>
>
> The SQL that follows the hint is interpreted as a comment. Thus I get:
>
> Caused by: java.sql.SQLException: ORA-00936: missing expression
>
> It works fine when I remove the hint.
> Is ibatis removing line breaks? I think this is a bug or at least an
> undesired behaviour in my case. Is there any workaround or idea?
>
> Thank you very much,
>
> --
> Guido García Bernardo - [EMAIL PROTECTED]
> Tfn. +34 983 54 89 08
> ITDEUSTO - Valladolid (Spain)
>
