Write Procedure in Oracle 10g for BIRT Report

Sunil1

You can create your own store procedure as per following:<br />
Create input and output variables.<br />
<br />
Following store procedure will return mulitple rows in single output variable.

create or replace
PROCEDURE ****_TAXBASE
( roleid IN NUMBER,
  reportmonth IN NUMBER,
  reportyear IN NUMBER,
  result OUT SYS_REFCURSOR
) AS
BEGIN
  OPEN result FOR SELECT * FROM
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT,cap2_assmnt_returns
  where
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.ROLE_ID = roleid and
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.REPORT_MONTH = reportmonth and
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.REPORT_YEAR = reportyear and
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.ROLE_ID = cap2_assmnt_returns.ROLE_ID and
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.REPORT_MONTH = cap2_assmnt_returns.REPORT_MONTH and
  CAP2_ASSMNT_TAXBASE_MNTLY_RPT.REPORT_YEAR = cap2_assmnt_returns.REPORT_YEAR ;
END ****_TAXBASE;

<br />
Thanks,<br />
Sunil