If it were Informix, you'd use:
execute procedure myprocedure($param1, $param2)
after worrying about whether the parameter values need to be quoted or not,
or:
execute procedure myprocedure(?,?)
and provide the parameters when you execute the statement. The backslashes
would be superfluous at best and erroneous at worst; the parentheses would
be necessary, as would the commas.
Since you're accessing MS SQL Server via DBD::Sybase and FreeTDS, I've no
idea what portion of my answer actually applies. You probably need to find
the syntax for SQL Server (likely the same as for Sybase given the common
ancestry), and use that.
--
Jonathan Leffler ([EMAIL PROTECTED])
STSM, Informix Database Engineering, IBM Data Management Solutions
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"
Karyn Ulriksen
<Karyn@Broadspire To: Jonathan Leffler/Menlo
Park/IBM@IBMUS, [EMAIL PROTECTED]
.com> cc: [EMAIL PROTECTED]
Subject: Where is the archive for this
list?
06/21/02 10:42 AM
I'd like to bookmark the mail archive site so that I don't have to go to
the
list to ask for the umpteenth million time what I know has been asked on
this list...
I'm having problems with calling an MS SQL stored procedure via DBI (using
FreeTDS DBD::Sybase).
I've tried the following formats:
$dbh->do("execute myprocedure $param1 $param2");
$dbh->do("execute myprocedure $param1, $param2");
$dbh->do("execute myprocedure \($param1, $param2 \)");
$dbh->do("execute myprocedure \($param1 $param2 \)");
Can someone throw me a bone?
K
