WIN32::OLE MSSQL return value

S

Saya

hi,

I have the below code and would like to know how I can access the
stored procedures returned value. Can anybody help me out here :).

my $cn=Win32::OLE-> new('Adodb.Command');
my $rs=Win32::OLE-> new('Adodb.Recordset');

$cn->{'CommandText'} = "stpCreateGroups";
$cn->{'CommandType'} = 4;
$cn->{'ActiveConnection'} = $sConString;
$cn->{'CommandTimeout'} = 1200000;
$cn->{'@strBranchAbb'} = $inpWorkareaPath;
$cn->{'@strGroupName'} = "vahu test";
$cn->{'@strHcp'} = "no";
$cn->{'@strGroupCreator'} = $sUser;
#$cn->{'@RETURN'};

$rs = $cn->Execute();

if(! ($rs = $cn->execute())) {
print "Error: " . Win32::OLE->LastError();
# $rs->close;
}

Regards
Says
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,756
Messages
2,569,535
Members
45,008
Latest member
obedient dusk

Latest Threads

Top