Use of instance update for Oracle Stored Procedure usage

Use of instance update for Oracle Stored Procedure usage

Body section

-- Update changes
 
Procedure proc_sy_syjs_updateChangeItem (fcoursecode in Rule XT. sy_syjs_proitem.fcoursecode % type,
Fcoursename in Rule XT. sy_syjs_proitem.fcoursename % type,
Fitemid in pair XT. sy_syjs_proitem.fitemid % type,
Fitemname in pair XT. sy_syjs_proitem.fitemname % type,
Flabmemnum in Rule XT. sy_syjs_proitem.flabmemnum % type,
Fstyle in Rule XT. sy_syjs_proitem.fstyle % type,
Ftype in Rule XT. sy_syjs_proitem.ftype % type,
Frequirement in Rule XT. sy_syjs_proitem.frequirement % type,
Fgroupnum in Rule XT. sy_syjs_proitem.fgroupnum % type,
Fdevicename in Rule XT. sy_syjs_proitem.fdevicename % type,
Fmodel in Rule XT. sy_syjs_proitem.fmodel % type,
Fhavenum in Rule XT. sy_syjs_proitem.fhavenum % type,
Fobsonum in Rule XT. sy_syjs_proitem.fobsonum % type,
Fbuynum in Rule XT. sy_syjs_proitem.fbuynum % type,
Funitprice in Rule XT. sy_syjs_proitem.funitprice % type,
Fproid in Rule XT. sy_syjs_proitem.fproid % type,
Fproitemid in Rule XT. sy_syjs_proitem.fproitemid % type

)
Is
Begin

Update into XT. sy_syjs_proitem st
Set st. fcoursecode = fcoursecode,
St. fcoursename = fcoursename,
St. fitemid = fitemid,
St. fitemname = fitemname,
St. flabmemnum = flabmemnum,
St. fstyle = fstyle,
St. ftype = ftype,
St. frequirement = frequirement,
St. fgroupnum = fgroupnum,
St. fdevicename = fdevicename,
St. fmodel = fmodel,
St. fhavenum = fhavenum,
St. fobsonum = fobsonum,
St. fbuynum = fbuynum,
St. funitprice = funitprice

Where st. fproid = fproid and st. fstageid = '2' and st. fproitemid = fproitemid and st. zt = '1 ';
Commit;


End;

Header file:

Procedure proc_sy_syjs_updateChangeItem (fcoursecode in Rule XT. sy_syjs_proitem.fcoursecode % type,
Fcoursename in Rule XT. sy_syjs_proitem.fcoursename % type,
Fitemid in pair XT. sy_syjs_proitem.fitemid % type,
Fitemname in pair XT. sy_syjs_proitem.fitemname % type,
Flabmemnum in Rule XT. sy_syjs_proitem.flabmemnum % type,
Fstyle in Rule XT. sy_syjs_proitem.fstyle % type,
Ftype in Rule XT. sy_syjs_proitem.ftype % type,
Frequirement in Rule XT. sy_syjs_proitem.frequirement % type,
Fgroupnum in Rule XT. sy_syjs_proitem.fgroupnum % type,
Fdevicename in Rule XT. sy_syjs_proitem.fdevicename % type,
Fmodel in Rule XT. sy_syjs_proitem.fmodel % type,
Fhavenum in Rule XT. sy_syjs_proitem.fhavenum % type,
Fobsonum in Rule XT. sy_syjs_proitem.fobsonum % type,
Fbuynum in Rule XT. sy_syjs_proitem.fbuynum % type,
Funitprice in Rule XT. sy_syjs_proitem.funitprice % type,
Fproid in Rule XT. sy_syjs_proitem.fproid % type,
Fproitemid in Rule XT. sy_syjs_proitem.fproitemid % type

);