Need simple example to call stored procedure

[thelordoftherings]

Hello,

Let's say I have stored procedure called "MyStoredProc" at my SQL server. Can someone please show me how to call this stored procedure and transfer parameters to it?

 

[sedj]

These links show you how :

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/CallableStatement.html

http://www.thirdeyeconsulting.com/jdbc.html

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk