Error Executing SQL Statement

[pjamack]

  I'm calling a function from my report(Oracle function) and the function works in Oracle and on Toad. It takes in a few variables, stores data in a temp table, opens and returns a cursor, etc.    All the Parameters and Fields in my JasperReport are set properly.

 JasperReport (Worked on in IReports 4.01) doesn't run in IReports or on JasperReports Server 4.01.  The same error comes up after I input the dates and info.   Always the 

 

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : Test Report 

etc etc...

 

 What needs to be changed?  I've written simple SQL Queries where I input some dates and returned fields. But with this function and other ones, I can't get any of them to work. They can't seem to execute the SQL.   

I write it as 

(?= call FUNCTION_GROUP.FUNCTION_NAME

(

                            $P{REPORT_START_DATE},

                            $P{REPORT_END_DATE},

                            $P{REPORT_PARAM}

       )

 

not sure what I'm doing wrong.