[Fwd: Cursors from EJB]

[Ritesh]

---

Hi

    I have  written a stored Procedure in sybase( on linux).
    in which i have a cursor which fetches the data for me
    and as per my requirement .
    It gives me more than one rows .
    If i run from commnad line it givens me perfect results.

    When i tried to run the procedure from session bean
    i got exception that this procedure can be run in chained mode only
    then i changed its transaction mode to chanined from unchained.

    After that it fetches data for me but
    I am getting only first record , not all

    i am calling procedure from session as follows

    CallableStatement  cS = connection.prepareCall("{call pro_PROSPECTINFO ?}")
    cS.setDouble(1,1.0)
    Resultset rS = cS.executeQuery();

    while (rS.next())
    {
      .......
    }


Can any body help me . ITS URGENT ,



Thanks in adavance
Ritesh

---