Results 1 to 2 of 2
- 09-10-2010, 04:07 PM #1
Member
- Join Date
- Nov 2008
- Posts
- 71
- Rep Power
- 0
- 09-10-2010, 04:47 PM #2
i believe this is done with a callable statement, where you bind the value as a java.sql.Timestamp
Java Code:CallableStatement stmt = con.prepareCall("{ exec myStoredProcedure(?) }"); // i think thats the callable kind of sql format ? stmt.setTimestamp(1, myDateTimeValue); // where you might need to convert a java.util.Date to a java.util.Timestamp here // and then other parameters, if any, then invoke the call
Similar Threads
-
Debug mySql stored procedure
By ulix83 in forum NetBeansReplies: 0Last Post: 10-29-2009, 12:48 PM -
How to call Oracle stored procedure from Java?
By parag_narkhede in forum New To JavaReplies: 4Last Post: 10-07-2009, 08:50 AM -
calling stored procedure through java
By KTR in forum JDBCReplies: 2Last Post: 01-30-2009, 01:53 PM -
stored procedure
By sankarigopi in forum JDBCReplies: 1Last Post: 11-13-2008, 05:53 PM -
How to get multiple rows from Stored Procedure
By SRJ1957 in forum Advanced JavaReplies: 0Last Post: 08-11-2008, 09:26 PM
Bookmarks