What is true about stored procedures?
A.
A stored procedure uses the DELCLARE keyword in the procedure specification to declare
formal parameters.
B.
A stored procedure is named PL/SQL block with at least one parameter declaration in the
procedure specification.
C.
A stored procedure must have at least one executable statement in the procedure body.
D.
A stored procedure uses the DECLARE keyword in the procedure body to declare formal
parameters.
Explanation:
The executable section must contain at least one executable statement. You
can include a NULL keyword to fulfill the need to have at least one executable statement in this
section.
For example,
BEGIN
NULL;
END