How to create and call stored procedures?

How to create and call stored procedures?  

To create stored procedures: Create procedure procedurename (specify in, out and in out parameters) BEGIN Any multiple SQL statement; END; To call stored procedures: CallableStatement csmt = con. prepareCall(”{call procedure name(?,?)}”); csmt. registerOutParameter(column no. , data type); csmt. setInt(column no. , column name) csmt. execute();

Blog Author: Vijay Kumar

Go to: Coding Problem Solutions, C C++ Aptitude