How to Execute Sybase Stored Procedure in Perl ?

See more:

Perl

database

script

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

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.