how to call a stored procedure that returns cursor??

From: Gerardo (gerardo_at_dangerous-minds.com)
Date: 06/16/04


Date: Wed, 16 Jun 2004 14:55:31 -0700

Hello all,

i have a stored procedure that returns a cursor.

i'm currently facing a problem trying to guess the right
syntax for calling such procedure, since SQL Server
syntax says the return variable should be passed as
argument.

it's easy to do so from SQL Query Analyzer, just
declaring a CURSOR variable before the execute. but how
to achieve this through jdbc??

i'll deeply appreciate any help
regards,
Gerardo.



Relevant Pages