We are currently assessing 'iReport' for use in a project.
On the 'Report query' screen, I select 'plsql' so that I can process plsql statements. However, when I enter a simple plsql statement ending with a ';', it gives and error of:
"Error:SQL problems:ORA-00911:invalid character"
When I remove the semicolon, the statement executes correctly as a sql statement, not a plsql statement.