"MJT" wrote:

> I am not certain this is the case with Sybase ... but I use DB2 and I cannot
> use that format for my parameters ... I have to enter my parameters as
> questions marks because I cant use "named parameters". The other thing to
> check is whether you have the command type on your dataset as "stored
> procedure" and not "text" or something else.
>
> "Arshad Syed" wrote:
>
> > 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