EnterpriseDB Stored Procedure UDS
Due to the unique nature of EnterpriseDB stored procedures, you cannot add them directly into a Logi JReport catalog. In this sense, the usage of Logi JReport Designer is limited when you use an EnterpriseDB database. As a substitute, Logi JReport has developed the User Data Source API which can use stored procedures in EnterpriseDB. The class name for EnterpriseDB stored procedures is EnterpriseDbProcedureUDS, in the package jet.datasource.enterprisedb.
In the following example, an EnterpriseDB stored procedure which is defined as follows will be added into a Logi JReport catalog.
create or replace package shdemo
as
type curtype
is
ref
cursor;
end shdemo;
create or replace procedure empquery (param1 in varchar2,
cur out shdemo.curtype) as lcur shdemo.curtype;
begin
open lcur for
select
*
from
emp
where
job = param1;
cur:=lcur;
end empquery;