By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,743 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,743 IT Pros & Developers. It's quick & easy.

SQL Server stored procedure output parameters.

P: n/a
Hello.

I'm having difficulty getting the value of output parameters from stored
procedures on a SQL server.
I understand that this just doesn't work with odbc so I've tried both the
mssql functions route, and the PDO route. In both instances I can execute the
query and iterate over the result set, but in both cases the variable bound to
the output parameter isn't having it's value changed.

In my searches online I've come across examples of how it 'should' work, and
plenty of posts of people unable to get it to work. Is there something special
that needs to be done to have it set?

The bind calls I'm trying are (mssql and PDO respectively)
mssql_bind($stmt, '@Output', $output, SQLINT4, true);
and
$stmt->bindParam(2, $OutPut, PDO::PARAM_INT|PDO::PARAM_INPUT_OUTPUT, 16);

I'm hoping someone can maybe shed some light on this, or at least point me in
a direction which has eluded me thus far.

Thanks,
David.
Mar 26 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
David Gillen schreef:
Hello.

I'm having difficulty getting the value of output parameters from stored
procedures on a SQL server.
I understand that this just doesn't work with odbc so I've tried both the
mssql functions route, and the PDO route. In both instances I can execute the
query and iterate over the result set, but in both cases the variable bound to
the output parameter isn't having it's value changed.

In my searches online I've come across examples of how it 'should' work, and
plenty of posts of people unable to get it to work. Is there something special
that needs to be done to have it set?

The bind calls I'm trying are (mssql and PDO respectively)
mssql_bind($stmt, '@Output', $output, SQLINT4, true);
and
$stmt->bindParam(2, $OutPut, PDO::PARAM_INT|PDO::PARAM_INPUT_OUTPUT, 16);

I'm hoping someone can maybe shed some light on this, or at least point me in
a direction which has eluded me thus far.

Thanks,
David.
Hi David,

This might help a little:
http://blog.stuartherbert.com/php/20...-2005-support/

The lower section named:
What’s Wrong With The Existing MSSQL Extension For PHP?

Also, M$ is making a new driver, read more here:
http://www.microsoft.com/sql/technol...p/default.mspx

Maybe it helps using their new version.
I am NOT sure because I didn't try it yet, but read some good reviews.
If that is an option for you: Give it a shot

Please report back here with your experiences.

Regards and good luck,
Erwin Moller
Mar 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.