1

Topic: Procedure or function expects parameter which has not been specified

There is a procedure.

ALTER PROCEDURE [dbo]. [SredniOklad5]
@oklad money OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SELECT @oklad=AVG (Salary) FROM Teachers
END

By means of ADOStoredProc I fulfill procedure in Delphi (without parameters) and I receive:
"Procedure or function SredniOklad5 expects parameter @oklad which has not been specified.
Like it and it it is not necessary to specify output parameter? How to solve a problem? Can from  as that on special to cause?

2

Re: Procedure or function expects parameter which has not been specified

Debusen wrote:

By means of ADOStoredProc I fulfill procedure in Delphi (without parameters)
...
Like it and it it is not necessary to specify output parameter?

It is necessary to fulfill procedure with parameter of type "day off".

3

Re: Procedure or function expects parameter which has not been specified

At least so:

@oklad money = null OUTPUT

For all remaining there is special a section at a forum.