This is probably a syntax error in your sql. That error message from
oracle often indicates a comma in the wrong place or parenthesis that is
unmatched. I would use your logs to see exactly what sql you're sending
to your database. Or else run your statements using sqlplus to see a
nice carat under the exact syntax problem.
Diran
Chema wrote:
Not, it isn't
The name is VIEW_JOB ( but the table name is FUTURE_JOB and works fine )
2006/3/29, Larry Meadors <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Does the view name have a # or $ character in it?
Larry
On 3/29/06, Chema < [EMAIL PROTECTED]
<mailto:[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
>
>
>
>
>
>
>
>
>
>
>
>
>
