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
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
