This section describes how to create a simple procedure that runs a simple query.
In order to test CallableStatement objects, I created a very simple stored procedure that updates the Point value of a Profile record:
C:\>sqlplus
Enter user-name: Herong/TopSecret
SQL> -- Creating a stored procedure
SQL> CREATE PROCEDURE UpdatePoint AS
2 BEGIN
3 UPDATE Profile SET Point = Point+1
4 WHERE FirstName LIKE 'Herong';
5 END;
6 /
Procedure created.
SQL> -- Checking the current Point value
SQL> SELECT ID, FirstName, Point FROM Profile
2 WHERE FirstName LIKE 'Herong';
ID FIRSTNAME POINT
---------- -------------------- ----------
1 Herong 0
SQL> -- Testing the procedure
SQL> EXECUTE UpdatePoint();
PL/SQL procedure successfully completed.
SQL> -- Checking the updated Point value
SQL> SELECT ID, FirstName, Point FROM Profile
2 WHERE FirstName LIKE 'Herong';
ID FIRSTNAME POINT
---------- -------------------- ----------
1 Herong 1
SQL>
"EXECUTE UpdatePoint()" is a command to test the stored procedure.
If made a mistake in the stored procedure, you can delete it from the server by the "DROP PROCEDURE UpdatePoint" command.
