CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Intermediate:
Issue calling SQL procedure


New User

Dec 20, 2011, 4:51 AM

Post #1 of 1 (1870 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);


print "$output\n";

Is this a PERL driver issue do you think?



Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives