SQL stored procedures and output

[archigamer]

I have the following stored procedure

CREATE PROCEDURE GetProductInfo
@productId int,
@productTitle varchar(100) output,
@productAvailability varchar(50) output,
@productManufacturer varchar(50) output,
@productDescription varchar(2000) output,
@productPrice float output
 AS
select @productTitle = p.product_title, 
		  @productPrice = p.product_price, 
		  @productDescription = p.product_description, 
		  @productManufacturer =  m.manufacturer_title, 
		  @productAvailability = a.availability_text
from product p 
right join availability a on p.product_id = a.availability_id
right join manufacturer m on p.product_manufacturer = m.manufacturer_id
where product_id = @productid;
GO

for some odd reason when I run it, it expects the @productTitle to be defined with a value? Can anyone explain why it would want it defined if its an output parameter or how I can fix it so it doesnt require a value to run it?

[r937]

oh man, it's been years since i wrote a stored proc, but don't you need to put the parameter list into parentheses?

CREATE PROCEDURE GetProductInfo
( @productId int
, @productTitle varchar(100) output
, ...
)
AS

rudy
http://r937.com/

[archigamer]

unfortunatly that has no effect on the results still asking for a value.

[MattR]

@productTitle varchar(100) = null output

[archigamer]

actually i found what the problem was, I declared @productId but in the where statement i had @productid, I am suprised that wasnt caught by enterprise manager, but oh well.