Oracle PL/SQL functions in Studio

[alexanderdav]

Hello,

 

I'm newish to Jaspersoft and related products. We're looking into implementing it for a few things around here, but before we can do that, we need to make sure it can handle the projects we need it for. 

 

Most of the reports we need it for utilize custom PL/SQL functions in the database. However, when I try to call one of those functions, I get an 'Invalid Identifier' error. I tried Googling and seaching these forums, but most results are aimed at iReport, not Studio.

 

Does anyone know how to get this working? An example of how we normally call the function is below:

WHERE ...

...

AND FN_GET_TASK_STATUS ( 'AGENCYNAME' , B1PERMIT.B1_PER_ID1 , B1PERMIT.B1_PER_ID2 , B1PERMIT.B1_PER_ID3 , 'Issue Permit' , 'Issue Permit,Issued' ) is Not Null 

[dnaboka]

Hi,

Have a look at the article on how to use PL/SQL in iReport:

http://community.jaspersoft.com/wiki/how-execute-ms-sql-stored-procedure-jasperreports-server

You might need to add jasperreports-extensions-3.5.3.jar to Studio classpath (Project/Properties/Java Build Path/Add External JARs)

 

[alexanderdav]

Actually, we found the problem. I was using a new 'read-only' account, and the person that created it didn't give it permissions to the functions. Once that was corrected, everything worked fine.