cyndiortega

I have no issues creating reports using SQL Server stored procedures, though.

Hello, I having looked everywhere on this forum and do not see a solution to my issue. I am researching creating reports in Jaspersoft Studio and deploying them to Jaspersoft Server Community. The problem is that I am using stored procedures with IN parameters and an OUT sys_refcursor. I have no issue rendering the reports in Jaspersoft Studio; however, they do not render in Jaspersoft Server. Here is an example of a simple stored procedure with an IN parameter and one OUT sys_refcursor. Is there anyway to get this to run in Jaspersoft Server? Any help would be appreciated. CREATE OR REPLACE PROCEDURE SP_AVAILABLE_DEPARTMENTS ( v_PARAM_OFFICE IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN OPEN l_CURSOR FOR SELECT * FROM ( SELECT -1 AS dprtmnt_id, ' All' AS dprtmnt_shrt_nm FROM DUAL UNION SELECT dprtmnt_id, dprtmnt_shrt_nm FROM dprtmnt WHERE ( '-1' IN ( v_PARAM_OFFICE ) OR dprtmnt_offc_id IN (SELECT Regexp_substr(v_PARAM_OFFICE , '[^,]+', 1, level) FROM dual connect by regexp_substr(v_PARAM_OFFICE , '[^,]+', 1, level) IS NOT NULL ) ) )results ORDER BY dprtmnt_shrt_nm ASC; END SP_AVAILABLE_DEPARTMENTS ;