|
 |
asp_databases thread: Too many parametres for procedure
Message #1 by "Richard Bukovansky" <richard.bukovansky@c...> on Wed, 14 Jun 2000 08:34:22 +0200
|
|
Hi,
I have trouble with calling my stored procedure on MS SQL 7.0 (SP1).
When I call a procedure in ASP, the error occure:
Too many arguments were supplied for procedure SaveObjTemp.
(there are 23 parametres I send to procedure and I have tested
if I don't missed anyone or give more parametres).
What's bad?
It looks that the stored procedure has limited number of parametres.
Thanx.
Richard Bukovansky
Message #2 by "Mukul Jain" <jainmukul@h...> on Wed, 14 Jun 2000 12:40:40 IST
|
|
Please elaborate ur question. there is no restriction as such of passing the
number of parameters on to the procedure
I have a sp that used 33 parameters and gives back 42 out
Mukul
From: "Richard Bukovansky"
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] Too many parametres for procedure
Date: Wed, 14 Jun 2000 08:34:22 +0200
Hi,
I have trouble with calling my stored procedure on MS SQL 7.0 (SP1).
When I call a procedure in ASP, the error occure:
Too many arguments were supplied for procedure SaveObjTemp.
(there are 23 parametres I send to procedure and I have tested
if I don't missed anyone or give more parametres).
What's bad?
It looks that the stored procedure has limited number of parametres.
Thanx.
Richard Bukovansky
Message #3 by "Richard Bukovansky" <richard.bukovansky@c...> on Wed, 14 Jun 2000 09:31:26 +0200
|
|
The problem solved!!! I copied the code from another ASP and
forgot to change the name of called stored procedure.
Thanx for support.
Richard Bukovansky
> From: "Richard Bukovansky"
> Reply-To: "ASP Databases" <asp_databases@p...>
> To: "ASP Databases" <asp_databases@p...>
> Subject: [asp_databases] Too many parametres for procedure
> Date: Wed, 14 Jun 2000 08:34:22 +0200
> Hi,
>
> I have trouble with calling my stored procedure on MS SQL 7.0 (SP1).
> When I call a procedure in ASP, the error occure:
>
> Too many arguments were supplied for procedure SaveObjTemp.
>
> (there are 23 parametres I send to procedure and I have tested
> if I don't missed anyone or give more parametres).
>
>
>
> What's bad?
> It looks that the stored procedure has limited number of parametres.
>
> Thanx.
>
> Richard Bukovansky
|
|
|
View Cart
