Get returning value from a stored procedure in C# : CSharp « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. CSharp

Get returning value from a stored procedure in C#

 


CallableStatement PreparedFunc = MyConnect.prepareCall("{ ? = call isodd( ? ) }");
PreparedFunc.registerOutParameter(1, Types.INTEGER);

PreparedFunc.setInt(1, aNumber);
PreparedFunc.execute();

if (PreparedFunc.getInt(1) == 1)
     System.out.println(aNumber + " is odd");
else
     System.out.println(aNumber + " is even");



        

Related examples in the same category