Call Stored Procedures
By specifying the name of the procedure, followed by its parameters, and ending with a semicolon. You can then use an SPL application to call another stored procedure.
name [ (parameters) ];
name is the procedure's identifier, and parameters refers to the list of actual parameters.
Note: If the procedure has no actual parameters to pass, then it should be run without parentheses.
The following is an example of calling a procedure from an anonymous block of code.
BEGIN
simple_procedure;
END;
That's all folks!
Note: Each application has its own way of calling stored procedures. For example, in Java applications, calls to stored procedures are made through the JDBC programming interface.
Delet Stored Procedures
We can use DROP PROCEDURE to remove a stored procedure from the database.
DROP PROCEDURE name;
name is the name of the procedure to be deleted
In the following example, we use the DROP PROCEDURE command to delete a previously created procedure.
DROP PROCEDURE simple_procedure;
See the DROP PROCEDURE command for more information.
Top comments (0)