Error on calling SP with output parameter 1

[hrhadin]

I have a simple sp:

create procedure [dbo].[sp_GetClinicLocation]
@cCID char(5),
@cLocation varchar(50) output
AS
BEGIN
SELECT @cLocation = cLocation
FROM AC
WHERE cClinic = @cCID
END

I'm trying to call the procedure as such:

declare @Test varchar(50)
exec sp_GetClinicLocation '22401',@Test = @cLocation
select @Test

I'm receiving the error message: Must declare the scalar variable @cLocation

Anybody know where I'm going wrong. I'm a stored procedure beginner.

 

[bborissov]

declare @Test varchar(50)
exec sp_GetClinicLocation '22401',@cLocation = @Test OUTPUT
select @Test

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[bborissov]

or

declare @Test varchar(50)
exec sp_GetClinicLocation @cCID = '22401',
                          @cLocation = @Test OUTPUT
select @Test

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[gmmastros]

Try...

declare @Test varchar(50)
exec sp_GetClinicLocation '22401',@Test [!]output[/!]
select @Test

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom