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 Designer is limited when you use an EnterpriseDB database. As a substitute, Logi Report has developed the User Data Source API, which enables you to use stored procedures in EnterpriseDB.
In the following example, we will add an EnterpriseDB stored procedure which is defined as follows into a Logi Report catalog.
create or replace package shdemo
create or replace procedure empquery (param1 in varchar2,
cur out shdemo.curtype) as lcur shdemo.curtype;
open lcur for
job = param1;