[sqr-users] No Value returned from Sybase Stored procedure

["Ian Mills" <Ian.Mills@orix.com.au>]

Hi all,

I was wondering if anyone would be able to help me with this strange
problem. I am trying to use a stored procedure running against a Sybase
database and the output variable doesn't contain any value. Source code
below. I have tested the stored procedure in a query analyser tool and
it works okay.

begin-procedure get_schedule($as_contract_number)
    declare-variable
        text    $as_contract_number
    end-declare
    execute osp_sec_calcschedule $as_contract_number, $_gs_schedule
out
    #debugt show ':' $_gs_schedule ':' 
end-procedure


I use similar functionality in 2 other reports and the values are
returned correctly. (shown below)
execute osp_arrears_calcfields $as_lease $as_port $as_branch $as_prod
$as_sub #ai_del1 out #ai_del2 out #ai_del3 out #ai_del4 out #ai_del5 out
#af_arrears out


I am running SQR v6.1.3

Any assistance will be appreciated.

Regards,
Ian Mills
Systems Analyst
ORIX Australia Corp Ltd

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users