cottemptomarti
Selectfromemployeewhere12To_charNVLeve
_
umber125SELECTe
ameINTOemp
ameFROMemployeeWHEREemp
oe
oEXCEPTIONOPENtoy_curFETCHtoy_curINTOmy_toy_priceFORsales_recINsales_curLOOPsales_rectsalessales_recasalesINOUTSELECTdept
oINTOdept_
oFROMempWHEREemp
oemp_
oRETURNresultpack_maorder_proc‘002’）BEFOREINSERTORUPDATEOFjobONempFOREACHROWUPPERNEWjob
fr