本文介绍了如何在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 = `
更多推荐
如何在Perl中执行Sybase存储过程?
发布评论