Hi All,
We are trying to call a DB2 procedure from hibernate layer. DB2 procedure has several IN and OUT parameters. Please find the below method declaration:

CREATE OR REPLACE PROCEDURE GET_VOYAGE_RECORD_LIST (
IN VOYAGE_LIST CHARARRAY,
IN CABIN_META CHARACTER(1),
IN PASTPASSENGER BOOLEAN,
IN WHEELCHAIRSUPPORT BOOLEAN,
IN CAMPAIGN CHARARRAY,
IN NO_OF_PAX INTEGER,
IN COUNTRY VARCHAR(50),
IN CURRENCY VARCHAR(50),
OUT RESULT_LIST DATAROW_ARRAY)
BEGIN
....
...

END;

How to CALL this procedure from hibernate layer? Any help will be really appreciated.