note 104302 deleted from function.mssql-execute by danbrown
| From: | danbrown@php.net | Date: | Tue, 07 Jun 2011 17:31:27 +0000 |
| Subject: | note 104302 deleted from function.mssql-execute by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-180316@lists.php.net to get a copy of this message | ||
Note Submitter: immanuel at ftfdesigns dot com
----
Thank you berk0081 !
FURTHER OBSERVATION: This "stored procedure execution failed" error in relation to
execution on Linux server does NOT only occur when trying to run a mssql_execute right after running
a "simple" mssql_query.
It will also show up when you run two mssql_execute back to back.
Using mssql_free_statement(), you will need to release previous statement before executing another.
<?php
//...
// Execute first procedure
$proc = mssql_init('some_proc', $conn);
mssql_bind($proc, '@ContactID', $cid, SQLINT4...;
$proc_result = mssql_execute($proc);
// Release the statement resource
mssql_free_statement($proc);
// Execute next procedure
$proc_two = mssql_init('some_proc', $conn);
$proc_result = mssql_execute($proc_two);
//...
?>