• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to use CallableStatement

 
Usama Rashwan
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic