Jump to content
Changes to the Jaspersoft community edition download ×

How can I execute a function that is defined in a package using Oracle/PLSQL in Jaspersoft Studio


lilyrh09

Recommended Posts

Hi community!

 

I have a (simple) working report in Crytal reports that I want to migrate to Jasper and my question comes when I need to call a function defined in a package from my Oracle DDBB.

 

My query looks like the following:

SELECT

table.field1 as field1,

table.field2 as field2,

sp_name.function_name(some parameters) as field3

FROM myTable table

WHERE ...

 

I've been googling a lot but everything leads me to dead ends.  I tried the following: 

SELECT

table.field1 as field1,

table.field2 as filed2,

{call sp_name.function_name(some parameters)} as field3

FROM myTable table

WHERE ...

 

...but I've got errors when trying to read the fields (Read Fields button). 

 

This is taking me a lot of time and I'm almost giving up...  Since I did it in crystal and it was such a simple task I can't imagine it takes this much to do it in Jasper.

Can anybody please clarify to me how can I achieve this? What exactly am I missing?

 

Big thanks!

Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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...