apower
New User
Dec 20, 2011, 4:51 AM
Post #1 of 1
(538 views)
|
|
Issue calling SQL procedure
|
Can't Post
|
|
Hi there
I have a perl function that calls a MS SQL procedure. That procedure returns a type "XML" that I can call fine from the sql server interface. When I execute the PERL though it complains about that output parameter:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 2 ('@Out_Xml'): Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types instead. (SQL-42000)
I have tried other types NVACHAR(MAX), etc..., all giving me the same error.
The actual perl call is as follows:
my $sth = $dbh->prepare ("{call dm_Custom_XML(?,?) }");
my $output;
my $i = "ESD%";
$sth->bind_param(1, $i);
$sth->bind_param_inout(2, \$output, 1);
$sth->execute();
print "$output\n";
Is this a PERL driver issue do you think?
Thanks,
Alan
|
MAIN
SEARCH
WHO'S 
LOG 