Jump to content
Changes to the Jaspersoft community edition download ×

calling a plsql function


Recommended Posts

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Generally you would call it as part of your query in the normal way, like this:



SELECT column1, colum2, yourfunction(somecolumn) as column3

FROM tablename;



If you just want to get a single piece of information for the header then you still use a query but embed the query in a subreport.

Link to comment
Share on other sites

  • 5 years later...


I'm a new user to ireport... How were you able to execute the plsql statements in ireport?

I am using ireport 4.6.0 to report straight from an oracle database and not with java.  The version of the db driver is ojdb6.jar.

Any help would be appreciated.... Thanks!!

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...