如何在Perl中执行Sybase存储过程？ [英] How to Execute Sybase Stored Procedure in Perl ?

问题描述

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存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！