Previous Topic Next Topic

EnterpriseDB Stored Procedure UDS

Due to the unique nature of EnterpriseDB stored procedures, you cannot add them directly into a Logi Report catalog. In this sense, the usage of Logi Report Designer is limited when you use an EnterpriseDB database. As a substitute, Logi Report 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 in to a Logi Report 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;

Add EnterpriseDB Stored Procedure UDS

Back to top

Previous Topic Next Topic