對MessageData表操作的包

CREATE OR REPLACE PACKAGE ALEXMONITOR.PKG_MessageData AS

 PROCEDURE InsertIntoMessageData(
                              area_Key in AlexMonitor.MessageData.Area%TYPE,
                              line_Name in AlexMonitor.MessageData.LineName%TYPE,
                               robotName in ALEXMONITOR.MESSAGEDATA.PNP_NAME%TYPE,
                              station_Name in AlexMonitor.MessageData.StationName%TYPE,
                              locationIndex in AlexMonitor.MessageData.LocationIndex%TYPE,
                              sn in AlexMonitor.MessageData.SN%TYPE,
                              result in AlexMonitor.MessageData.Result%TYPE,
                              start_Time in AlexMonitor.MessageData.StatTime%TYPE,
                              stop_Time in AlexMonitor.MessageData.StopTime%TYPE,
                              errorCode in AlexMonitor.MessageData.symptom_code%TYPE,
                              errorDesc in AlexMonitor.MessageData.symptom_desc%TYPE,
                              out_var out number);
                             
 PROCEDURE GetLineInputOutPut(
                                             area_Key in AlexMonitor.MessageData.Area%TYPE,
                                             line_Name IN AlexMonitor.MessageData.LineName%TYPE,
                                             Line_Input  out  number,
                                             Line_output  out number,
                                             beginTime  in  varchar2,
                                             endTime    in varchar2
                                             );
                                            
 PROCEDURE GetStationInputOutPut(
                                             area_Key in AlexMonitor.MessageData.Area%TYPE,
                                             line_Name IN AlexMonitor.MessageData.LineName%TYPE,
                                            station_Name IN AlexMonitor.MessageData.StationName%TYPE,
                                             station_Input  out  number,
                                             station_output  out number ,
                                             beginTime  in  varchar2,
                                             endTime    in varchar2
                                             )  ;
 PROCEDURE GetPNPInputOutPut(
                                             area_Key in AlexMonitor.MessageData.Area%TYPE,
                                             line_Name IN AlexMonitor.MessageData.LineName%TYPE,
                                             robotName in AlexMonitor.MESSAGEDATA.PNP_NAME%TYPE,
                                             beginTime  in  varchar2,
                                             endTime    in varchar2,
                                             PnP_Input  out  number,
                                             PnP_output  out number
                                             )  ;
                                            
 PROCEDURE GetStationIndexInputOutPut(
                                             area_Key in AlexMonitor.MessageData.Area%TYPE,
                                             line_Name IN AlexMonitor.MessageData.LineName%TYPE,
                                             station_Name IN AlexMonitor.MessageData.StationName%TYPE,
                                             stationIndex IN ALEXMONITOR.MESSAGEDATA.LOCATIONINDEX%TYPE,
                                             station_Input  out  number,
                                             station_output  out number ,
                                             beginTime  in  varchar2,
                                             endTime    in varchar2
                                             )  ;
                                            
 PROCEDURE GetStationRetest(
                                             area_Key in AlexMonitor.MessageData.Area%TYPE,
                                             line_Name IN AlexMonitor.MessageData.LineName%TYPE,
                                             station_Name in AlexMonitor.MESSAGEDATA.StationName%TYPE,
                                             beginTime  in  varchar2,
                                             endTime    in varchar2,
                                             total_Test  out number,
                                             station_Input  out  number
                                             ) ;
                                                                  
 end PKG_MessageData;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26851211/viewspace-753071/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26851211/viewspace-753071/