Java JDBC Stored Procedure

Description

Click the following links for the tutorial for JDBC and Stored Procedure.

1. Stored Procedure accepts no parameters and returns no value
2. Stored Procedure accepts two IN parameters and does not return any value.
3. Stored Procedure accepts an IN parameter and returns an integer value.
4. Stored Procedure accepts two IN parameters and two OUT parameters.
5. Invoking Stored Procedures
6. Stored Procedure Creation and Call for Oracle
7. Stored Procedure Creation and Call for MySQL
8. Create a function named myfuncinout that returns a VARCHAR value; the function has an IN/OUT parameter named x.



9. Create a function named myfuncin which returns a VARCHAR value
10. Create a function named myfuncin which returns a VARCHAR value; the function has an IN parameter named x
11. Create a function named myfunc which returns a VARCHAR value; the function has no parameter
12. Create procedure myprocinout with an IN/OUT parameter named x
13. Create procedure myprocout with an OUT parameter named x
14. Create procedure myprocin with an IN parameter named x. IN is the default mode for parameter
15. Create procedure myproc with no parameters
16. Getting the Stored Procedure Names in a Database



17. Calling a Stored Procedure in a Database
18. Calling a Function in a Database
19. Controlling the type value of the OUT parameter