I have a store procedure from my dbaTeam , Here is the stored procedure, and temp table created . All I want to know here , how to map the temp table to the output value while calling the procedure in java .

    Create or replace package body package_name IS
    procedure procedure_name (
Id IN Long,
sDate IN DATE,
eDate in DATE,
Ind OUT package_name.pkg_Type,
Sol OUT VARCHAR2)
BEGIN
query (NOTE : Obtaining the results from multiple Tables)
end

Create or replace package package_name AS TYPE typ IS RECORD(id Integer,Name String);
TYPE pkg_Type IS TABLE OF typ INDEX BY BINARY_INTEGER;
PROCEDURE procedure_name(Id IN Long,sDate IN DATE,eDate in DATE,Ind OUT package_name.pkg_Type,Sol OUT VARCHAR2)