Php procedure sqlsrv script with MSSQL error

I would also need help with the procedure. I have written this code in php

      $sql = "EXEC EXPORT_DAT @id_w = '".$id_w."'";    $stmt = sqlsrv_prepare($link, $sql);    if (!sqlsrv_execute($stmt)) {  echo die( print_r( sqlsrv_errors(), true));    }    else     {    while($row  = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_NUMERIC)) {    $value[] = $row;    }    echo json_encode($value);    }  

but the procedure returns this error.

Array ( [0] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]CREATE TABLE tbl_point_50000263 (id varchar (max)) [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]CREATE TABLE tbl_point_50000263 (id varchar (max)) ) )

I don't know what can be wrong because C # it works.

Thank you

https://stackoverflow.com/questions/67444575/php-procedure-sqlsrv-script-with-mssql-error May 08, 2021 at 02:05PM