| The Duke 2005-02-03, 4:00 pm |
| Attempt to use the following Stored procedure to update the contents of
a datawindow and it result in the error: "wrong number of parameters":
create procedure dba.charge_pay_rate_insert(in a_clientno char(10),
in a_wkday_charge numeric(5,2),
in a_sat_charge numeric(5,2),
in a_sun_charge numeric(5,2),
in a_sleepover_charge numeric(5,2),
in a_wknight_charge numeric(5,2),
in a_bank_hol_charge numeric(5,2),
in a_wkday_pay numeric(5,2),
in a_sat_pay numeric(5,2),
in a_sun_pay numeric(5,2),
in a_sleepover_pay numeric(5,2),
in a_wknight_pay numeric(5,2),
in a_bankhol_pay numeric(5,2))
begin
insert into chargepay_rate_mst values(
a_clientno,
a_wkday_charge,
a_sat_charge,
a_sun_charge,
a_sleepover_charge,
a_wknight_charge,
a_bank_hol_charge,
a_wkday_pay,
a_sat_pay,
a_sun_pay,
a_sleepover_pay,
a_wknight_pay,
a_bankhol_pay);
commit work
end
Below is the description of the Charge_pay_rate table:
TABLE "dba"."chargepay_rate_mst" ("clientno" char(10) NOT NULL DEFAULT
NULL,
"wkday_charge" bigint NOT NULL DEFAULT NULL,
"sat_charge" bigint NOT NULL DEFAULT NULL,
"sun_charge" bigint NOT NULL DEFAULT NULL,
"sleepover_charge" bigint NOT NULL DEFAULT NULL,
"wknight_charge" bigint NOT NULL DEFAULT NULL,
"bankhol_charge" bigint NOT NULL DEFAULT NULL,
"wkday_pay" bigint NOT NULL DEFAULT NULL,
"sat_pay" bigint NOT NULL DEFAULT NULL,
"sun_pay" bigint NOT NULL DEFAULT NULL,
"sleepover_pay" bigint NOT NULL DEFAULT NULL,
"wknight_pay" bigint NOT NULL DEFAULT NULL,
"bankhol_pay" bigint NOT NULL DEFAULT NULL ,
PRIMARY KEY ("clientno")) ;
Please advise on how I can overcome this problem.
|