parameterized stored procedure

[IanH]

I've use EA to create simple sprocs like:

create procedure sp_mysproc
as

select * from mytable
;


but I've been unable to figure out how to create one that has parameters, for example:

create procedure sp_mysproc
(
  @input_param  varchar(12)
  @output_param varchar(50)   output
)

Select * from mytable
;


Anyone have any hints?
Thanks,
-Ian