Stored procedures allow you to bundle SQL commands for easy access. They
are infrequently called system procedures. You execute the procedure by its
name followed by a comma separated list of arguments. Unlike procedure calls in
the Oracle database, you do not surround parameters with parentheses for the
call.
When you pass parameters to a stored procedure, the order of parameters
should match the order in which they are defined in the stored procedure.
Alternatively you can explicitly specify the parameter names when you supply
the parameters.
To get rid of a stored procedure, you need to
DROP it. You can look at stored procedure metadata in the “sys.procedures”
view.
