Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Procedure do not work

Author  Topic 

velasquez
Starting Member

1 Post

Posted - 2000-10-26 : 07:08:12
Hi


When I tried to execute a procedure it give me message:

"Too many arguments were supplied for procedure sp2_ge_ag15_01"

I am doing:
exec sp2_ge_ag11_01 306,'NOVO VELHO',Null,
'1968-04-15','M',90,.17,'novo@com.br','teste'
It has 9 parameters

the begin of the my procedure is:

CREATE procedure dbo.sp2_ge_ag11_01(@Pcd_ficha integer,
@Pnm_ficha varchar(60),
@Pcd_pac integer = null,
@Pdt_nas datetime,
@Psx_pac varchar(01),
@Ppes_pac smallint,
@Palt_pac float,
@Pemail1 varchar(50),
@Pobs varchar(254))

AS
etc...

What Happen

thank you in advance

A Benção de Deus enriquece e não Acrescenta Dores
   

- Advertisement -