[#5774] - "Query language: plsql" is not processing plsql statements

Category:
Bug report
Priority:
Urgent
Status:
Assigned
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

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.

lclc's picture
3
Joined: Jun 5 2012 - 8:55am
Last seen: 9 years 3 months ago

2 Comments:

#1

I am using ireport to report straight from an oracle 11g database and not through a java application. I am using windows xp.

#2

In Options, it shows:

Language: PLSQL
Factory Class: com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory
Field Provider Class: com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider

Is the field provider class correct? If not, would you be able to point me to where I can obtain the correct plugin for plsql?

Feedback
randomness