Hello Gurus,

I have following Stored Procedure defined in the SQL Server 2000
database.

CREATE Procedure GetEmpDetails
(
 @fromdate varchar(25),
 @todate varchar(25)
)
as
Begin
   select empno,
          ename,
          sal,
          managerID
     from emp
    where hiredate between @fromdate and @todate
End

The above Stored Procedure returns more than one rows.
I have to wirte JDBC code which uses Callable Statement.

Could anyone provide me the source code for the same.

Thanks in advance

Regards
Sanjeev
sanjeev.atvankar@gmail.com