Get cusor from SQLServer StoreProcedure to Java Program

[YuenLian Wu]

Dear all,

I am currently using JDBC connecting to SQLServer StoreProcedure using CallableStatement. I am encountering a very annoying problem, which is the cursor thing. I have the cursor declared from storeProcedure like the following:

    
declare getCustomerQuotaInfo CURSOR STATIC READ_ONLY FOR 
select quota_code, init_quota_amt, avail_quota_amt, quota_assigned_date, quota_unlocked_date, last_withdrawal_date
from tbl_gtrs_customer_quota
where ac_no = @acc_no and avail_quota_amt <> 0
order by quota_assigned_date

Is it possible for me to retrieve this celestial cursor to java program?

myriads Thanks

Transistor
[ July 20, 2006: Message edited by: YuenLian Wu ]