如何在Perl中执行Sybase存储过程？

本文介绍了如何在Perl中执行Sybase存储过程？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

Hello All， 我正在以下列方式在Sybase中执行Stored Proc。它执行得很好。我要打印OUT值。

Hello All, I'm executing Stored Proc in Sybase in the following way. It's executing fine. I've to print the OUT value.

DECLARE @MyCount INT DECLARE @MyDate DATETIME EXEC proc_MyProcName_update @MyDate OUT, @MyCount OUT SELECT @MyCount, @MyDate

但不知何故我无法在Perl& amp;获取两个不同变量的返回值。然后我想打印变量。你可以帮帮我吗？

But somehow I'm unable to run this in Perl & to get the return values in two different variables. And then I wanna print the variables. Could you please help me out ?

$SP="proc_MyProcName_update"; print SQL "exec $SP\n" ; print SQL "go" ; $var = `$ISQLPATH/isql -U$USER -P$PASSWORD -S$SERVER -D$DATABASE -i$SQL`; print "\n$var\n"; print OUT $var;

请帮帮我。 先谢谢。

Please help me. Thanks in Advance.

推荐答案

SP = proc_MyProcName_update; print SQL exec SP="proc_MyProcName_update"; print SQL "exec

SP \ n; print SQL go; SP\n" ; print SQL "go" ;

var =` var = `