Re: Perl-SQL-ADO-Stored proedures

PLEASE WRAP YOUR CODE IN <CODE> TAGS.

I've never heard of the bind_param_inout method. Perhaps just try passing $y to your execute?

$sth = $dbh->prepare("execute sp_test_1 ?");
$sth->execute($y) or die "execute: $!";
[download]

If 'execute' has problems with that, or it complains about your bind values, just shove it all into the same SQL statement:

$dbh->do("execute sp_test_1 '$y'");

# or
$sth = $dbh->prepare("execute sp_test_1 '$y'");
$sth->execute;
[download]

Of course, this is assuming that your SQL syntax is valid (which you seem to indicate it the case). I've never seen an 'execute' keyword used in SQL like that before, but my experience is not with ADO.

Comment on Re: Perl-SQL-ADO-Stored proedures Select or Download Code

Replies are listed 'Best First'.
RE: Re: Perl-SQL-ADO-Stored proedures by extremely (Priest) on Nov 11, 2000 at 03:37 UTC
From my MS-SQL manual: Executes a system procedure, a user-defined stored procedure, or an extended stored procedure. Also supports the execution of a character string within a Transact-SQL batch. In general, you can ditch the "EXECUTE" when calling stored procedures. (sp_...) so you don't often see it. It's good form to use it tho, especially when you combine it with other SQL. -- $you = new YOU; honk() if $you->love(perl)	[reply]

Replies are listed 'Best First'.

RE: Re: Perl-SQL-ADO-Stored proedures
by extremely (Priest) on Nov 11, 2000 at 03:37 UTC

From my MS-SQL manual:

Executes a system procedure, a user-defined 
stored procedure, or an extended stored procedure. 
Also supports the execution of a character string 
within a Transact-SQL batch.

In general, you can ditch the "EXECUTE" when calling stored procedures. (sp_...) so you don't often see it. It's good form to use it tho, especially when you combine it with other SQL.

--
$you = new YOU;
honk() if $you->love(perl)

[reply]