i need help to call this procedure
ED_S_ATTENDANCE , ED_S_DEPARTURE
CREATE OR REPLACE PROCEDURE TS_CalcOverTime (
P_dStartTime DATE , P_dEndTime DATE ,
P_nDayDate DATE , P_nDayType NUMBER ,
P_nEM_TS_PL_CODE Number ,
P_nOverTime1 OUT NUMBER , P_nOverTime2 OUT NUMBER ,
P_nOverTime3 OUT NUMBER , P_nOverTime4 OUT NUMBER)
how to call it using CallableStatement ???
ED_S_ATTENDANCE , ED_S_DEPARTURE
CREATE OR REPLACE PROCEDURE TS_CalcOverTime (
P_dStartTime DATE , P_dEndTime DATE ,
P_nDayDate DATE , P_nDayType NUMBER ,
P_nEM_TS_PL_CODE Number ,
P_nOverTime1 OUT NUMBER , P_nOverTime2 OUT NUMBER ,
P_nOverTime3 OUT NUMBER , P_nOverTime4 OUT NUMBER)
how to call it using CallableStatement ???