Re: calling a stored procedure using DBI.pm

Did you:

...
my $sth = $dbh->prepare($StoredProcedureSQL);
if(!$sth->execute(@args)) {
    print "Met with error: ", $sth->errstr, "\n";
    # exit / die / croak / return / next / last
}
while ( my $row = $sth->fetchrow_arrayref ) {
    ...
}
...
[download]

Cuz I've done that a million times on Sybase without any problems. Also, check $sth->rows.

-brad..

Comment on Re: calling a stored procedure using DBI.pm Select or Download Code

Replies are listed 'Best First'.
Re^2: calling a stored procedure using DBI.pm by aroc725 (Acolyte) on Apr 12, 2006 at 20:28 UTC
Thanks to everyone who took the time to respond. I think the documentation may be slightly off. Here's what appears in the documentation I was referred to: ... $sth = $dbh->prepare("declare \@id_value int, \@id_name exec my_proc @name = 'a string', @number = 1234, @id = @id_value OUTPUT, @out_name = @id_name OUTPUT"); ... Question - isn't the backslash (\) character needed in front of every '@' character within the string containing the stored procedure call ?	[reply]
Re^3: calling a stored procedure using DBI.pm by runrig (Abbot) on Apr 12, 2006 at 23:05 UTC
isn't the backslash (\) character needed in front of every '@' character within the string... Yes it is. I think under older perls, it may have been just a warning, but now you definitely need the backslash to not try to interpolate arrays in a double quoted string (and is a fatal error under use strict if you try to interpolate a non-existant array).	[reply]
Re^3: calling a stored procedure using DBI.pm by roboticus (Chancellor) on Apr 12, 2006 at 23:47 UTC
Yes, or you could use a single-quoted string.	[reply]
Re^3: calling a stored procedure using DBI.pm by mpeppler (Vicar) on Apr 13, 2006 at 19:19 UTC
You are correct - the backslashes are missing, a typo in the docs which I'll correct. Michael	[reply]