2,497
社区成员
发帖
与我相关
我的任务
分享
Create Or Replace Package ChargePKG
As
Type ChargeCursor Is REF Cursor;
Procedure GetCarSortChargeData(Dep VARCHAR2,
ClassNO VARCHAR2,
MorningShiftOnDuty VARCHAR2,
MorningShiftOffDuty VARCHAR2,
MiddleShiftOnDuty VARCHAR2,
MiddleShiftOffDuty VARCHAR2,
NightShiftOnDuty VARCHAR2,
NightShiftOffduty VARCHAR2,
CarSortChargeCursor Out ChargeCursor) ;
End ChargePKG;
/
CREATE OR REPLACE PACKAGE BODY ChargePKG AS
Procedure GetCarSortChargeData(Dep VARCHAR2,
ClassNO VARCHAR2,
MorningShiftOnDuty VARCHAR2,
MorningShiftOffDuty VARCHAR2,
MiddleShiftOnDuty VARCHAR2,
MiddleShiftOffDuty VARCHAR2,
NightShiftOnDuty VARCHAR2,
NightShiftOffduty VARCHAR2,
CarSortChargeCursor Out ChargeCursor)
Is
Begin
Insert Into TempGratisCarTable(CarID,CarTpye,CriterionWeight,WholeWeight) Values(1,2,3,4);
Open CarSortChargeCursor For Select * From TempGratisCarTable;
return;
End GetCarSortChargeData;
END ChargePKG;