Hi,

I created a test procedure as below. However, when I execute the proc, I
get the message stating: Procedure test_sp expects parameter @fldofc which
was not supplied. In the Parameters tab I have made the assignment properly.
Also, I added them to the Report Parameters in the main menu. When I call the
proc in the Query string, I have tried all these options:

1.) exec test_sp @fldofc, @csmplmkt
2.) test_sp
3.) exec test_sp

Nothing works! I am using Sybase ASE 12.5. Please help!! Thanks in advance.
The proc is below. (Arshad)

create proc test_sp
       @fldofc        int ,
       @csmplmkt      int
as
begin

select * from cdv

end
go