如何在程序中取得Sybase数据库存储过程的返回值?
Jonea 2003-06-18 05:50:40 在Sybase数据库中有一存储过程
ALTER PROCEDURE TEST(@product_id INTEGER,@type1 char(10) output) as
begin
if @product_id = 1
select @type1 = 'HI'
if @product_id = 2
select @type1 = 'Ni hao'
end
PB:中写
int li_test
string li_type
declare lpr_test procedure for test
@product_id = :li_test,
@type1 = :li_type;
execute lpr_test;
fetch lpr_text into :li_type;
系统提示“cursor is not open”
请问什么原因