首先,编写存储过程:
1、先创建包:
CREATE OR REPLACE PACKAGE TEST_PACKAGE IS
TYPE TEST_CURSOR IS REF CURSOR;
PROCEDURE TEST (TEST_CURSOR OUT TEST_CURSOR,NUM in number);
END TEST_PACKAGE;
接下来创建存储过程:
CREATE OR REPLACE PACKAGE BODY TEST_PACKAGE IS
PROCEDURE TEST (TEST_CURSOR OUT TEST_CURSOR,NUM in number) IS
BEGIN
OPEN TEST_CURSOR FOR
SELECT * FROM TEST_TABLE WHERE ID=number;
END TEST;
end TEST_PACKAGE;
之后就在BIRT报表设计器里
call TEST_PACKAGE.TEST(?,?)