How to call Stored Procedure using Class

[arjay_comsci]

hey guys,,I need some help on how to call the stored procedure using classes,,

 

I have my weeklyevent.sql file that contains stored procedure.One of this is updating a record

drop procedure editweeklyevent$$

create procedure editweeklyevent (

i_ses  bigint,

i_weid  int,

i_strt  date,

i_end  date,

i_act  smallint,

i_min  smallint,

i_vis  tinyint,

i_name  varchar(40),

i_cc    varchar(80),

i_cont  int,

i_ban  varchar(40),

i_desc  text

) begin

 

select person into @uid from usersession where sessionid=i_ses;

 

update weeklyevent set starton=i_strt, endon=i_end, activity=i_act, ministry=i_min,

visibility=i_vis, name=i_name, editon=curdate(), editby=@uid,

childcare=i_cc, contact=i_cont, banner=i_ban, descr=i_desc

where weid=i_weid;

 

end$$

and this is code using my Inline sql code

$eweid=$_POST['weid'];

$ename=$_POST['name'];

$eminid=$_POST['ministry'];

$econtact=$_POST['contact'];

$descr=$_POST['descr'];

$esql="Update weeklyevent SET name='$ename', ministry='$eminid', descr='$descr', contact='$econtact' where weid='$eweid'";

$vdb->Execute($esql);

 

I want to use stored procedure on it..How to call that procedure?..If you request my copy of my Class I will post it..