MSSQL Stored Procedure - expects parameter xxx not supplied
Posted: 04.07.2009, 10:45
Delphi 5 Pro + Zeos 6.6.3, Zeos 6.6.5 + MSSQL 2005.
I recently updated to zeos 6.6.3 to 6.6.5. It has a problem on executing stored procedure using mssql dblib protocol. But only happen on procedure which have output params.
It works on the first execution, but show err messages on the next execution as
"Procedure of Function 'procedure_name' expects parameter '@xxxx', which was not supplied".
It does not happen to connection protocol using ADO, or even in firebird 2.1. It also does not happen if I create the zstoredproc run time.
I tried to search in available topics. Is this only happen to mssql protocol?
I recently updated to zeos 6.6.3 to 6.6.5. It has a problem on executing stored procedure using mssql dblib protocol. But only happen on procedure which have output params.
It works on the first execution, but show err messages on the next execution as
"Procedure of Function 'procedure_name' expects parameter '@xxxx', which was not supplied".
It does not happen to connection protocol using ADO, or even in firebird 2.1. It also does not happen if I create the zstoredproc run time.
I tried to search in available topics. Is this only happen to mssql protocol?