Does the view name have a # or $ character in it? Larry
On 3/29/06, Chema <[EMAIL PROTECTED]> 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 > > > > > > > > > > > > >
