Callable Statement

[Akshayan Venkatesh]

How to use CallableStatement in JDBC? with example ...

..Akshayan

[pascal betz]

how to ask questions: http://faq.javaranch.com/view?HowToAskQuestionsOnJavaRanch
interesting for you:

SearchFirst
CarefullyChooseOneForum


btw: google is your friend one of the first hits for "callablestatment and example": http://www.javaskyline.com/learnjdbc.html


p

[Shaan Shar]

Akshayan Venkatesh,

I think that you are not working ownself but anyways this is the example to use callableStatements.

Connection con = getCOnnection(//Your Stuff);
CallableStatement cs=null;
cs = con.prepareCall(//Write down your StoredProcedure here);
//If You have Input Parameters
cs.setString(index,value);
//If you have output parameter
cs.registerOutParameter(index,Types.VARCHAR);
...
...
...
cs.executeUpdate();

But it's better for you to try yourself. Don't post the thread without at least one homework done by yourself.