got it. The problem was semicolon at the end of the select comment.
Interesting the report creator doesn't allow semicolon in a statement.
Sp
"SP" <sdpantDeleteTOReply_at_yahoo.com> wrote in message
news:SFjla.8959$8Z5.57305_at_sea-read.news.verio.net...
> I'm getting the follwoing error when I try to view the report created on
OEM
> version 9 release 2 in widnows 2000 that you can view from a web browser.
> The query I wrote is "select first_name fom user;" is simple enough. I
> don't know from where it is adding other characters. Am I missing
someting?
>
> Processing of report element # 1 failed: exception VdbSQLException{wstring
> reason="ORA-00911: invalid character\n";long oracleError=911;long
> errorCode=3;wstring sqlStmt="/* OracleOEM */ select first_name
> \"first_name\" from user;";}
>
> TIA,
> SP
>
>
>
Received on Fri Apr 11 2003 - 12:35:50 CDT
