ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Views and dynamic queries
Date Wed, 29 Mar 2006 14:16:47 GMT
Does the view name have a # or $ character in it?

Larry


On 3/29/06, Chema <chemagogia@gmail.com> wrote:
>  Hello:
>
> I've got this query in sqlmap config file
>
> <select remapResults ="true" id="getValue" resultClass="java.lang.Object"
> parameterClass="QueryClass">
>       SELECT     $c$
>       FROM     $table$
>       WHERE     $where$
>  </select>
>
>
>
> If $table$ is the name of a view , this error happens:
> ORA-00921: unexpected end of SQL command
>
> If $table$ is the name of a table, all works fine
>
> why ?
>
> Thanks in advance
>
> Best regards
>
>
>
>
>
>
>
>
>
>
>
>
>

Mime
View raw message