Programming Aid Coad

1. try {
2. // Call a function that takes NO parameters
3. cs = connection.prepareCall("{call procedure_name}");
4. cs.execute(); //execute the stored procedure
6. // Call a function that takes a String IN parameter
7. // An IN parameters is when you input a value
8. // for the stored procedure
10. cs = connection.prepareCall("{call procedure_name_in(?)}");
11. cs.setString(1, "ABC"); // Set the value for the IN parameter
12. cs.execute();
14. // Call a function that returns a String OUT parameter
15. // An OUT parameter is when the stored procedure
16. // has an output value
18. cs = connection.prepareCall("{call procedure_name_out(?)}");
19. cs.registerOutParameter(1, Types.VARCHAR);
20. // Register the types of the return value and OUT parameter
21. cs.execute();
22. String outParam = cs.getString(1); // OUT parameter
24. // Call a function with one IN/OUT parameter
25. // An IN/OUT parameter has been an input and an output
27. cs = connection.prepareCall("{call procedure_name_inout(?)}");
28. cs.registerOutParameter(1, Types.VARCHAR);
29. cs.setString(1, "ABC");
30. cs.execute();
31. String outParam = cs.getString(1);
32. } catch (SQLException e) {
33. }