reporting output of a PL/SQL call

EdK01

I'm trying to retrieve the output of a PL/SQL call below.

The objective is to retrieve the 3 strings olist1...olist3 below, and pass them on to 3 columns on the 'layout'. This will be a single-call report - the PL/SQL does all the logic to get the right results.

The code below is required to invoke the PL/SQL procedure NEXTEQNU.

Putting the below in the Open method does NOT work. Probably because of the ';'s.

How can I handle this in BIRT?

Thanks
Ed K



sqlText = "DECLARE "
+ "olist1 VARCHAR2(20000);"
+ "olist2 VARCHAR2(20000);"
+ "olist3 VARCHAR2(20000);"
+ "BEGIN "
+ " NEXTEQNU('" + params["leading_string"] + "'," + params["count"] + ","
+ "olist1,olist2,olist3);"
+ " END; "
;