"Query language: plsql" is not processing plsql statements - iReport Designer - Jaspersoft Community

Jump to content

"Query language: plsql" is not processing plsql statements
By lclc

June 9, 2012
Share

Followers 0
Assigned User Giulio Toffoli

CategoryBug report

PriorityUrgent

ReproducibilityAlways

ResolutionOpen

SeverityCritical

StatusAssigned
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.
Share
Followers 0
Go to bugs

User Feedback
2 Comments
Recommended Comments

lclc 0

Posted June 11, 2012

Share this comment

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

Link to comment

Share on other sites

lclc 0

Posted June 11, 2012

Share this comment

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?

Link to comment

Share on other sites

×

×

Create New...