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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



apower
New User

Dec 20, 2011, 4:51 AM

Post #1 of 1 (945 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

 
 


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

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