This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to use CallableStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to use CallableStatement " Watch "how to use CallableStatement " New topic
Author

how to use CallableStatement

Usama Rashwan
Ranch Hand

Joined: Oct 10, 2001
Posts: 33
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 ???


SCJP2, SCWCD , SCEA Part I<br />Enterprise Application Development with IBM WebSphere Studio, V5.0<br />IBM Certified Solution Developer - WebSphere Studio, V5.0<br />IBM 483 (Enterprise Connectivity with J2EE)<br />IBM Certified Specialist - IBM WebSphere Application Server, Advanced Single Server Edition for Multiplatforms, V4.0
 
jQuery in Action, 2nd edition
 
subject: how to use CallableStatement
 
Similar Threads
Comparing two Dates
JDBC, Stored Procedure and Rowtype
callableStatement.execute()
Resultset returned by PL/SQL function
Calling Oracle stored procedures in JRun container