Pl sql stored procedure:
The pl sql stored procedure is a named PL/SQL block which performs one or more specific tasks. A pl sql stored procedure can be divided into two parts: Header and Body part.
Header: The header part contains the name of the procedure and the parameters passed to the procedure.
Body: The body part contains declaration section, execution section and exception section.
Note: A pl sql stored procedure do not return a value directly.
Procedure example without parameters:
CREATE OR REPLACE PROCEDURE hello_world AS BEGIN dbms_output.put_line('Hello World!'); END; /
DROP PROCEDURE procedure_name;
See more at: Plsql stored procedure.
- How to create a procedure?
- How to execute stored procedure?
- How to drop stored procedure?
- How to create a function?
- How to execute a function?
- How to drop a function?
- What is Context area?
- How to use explicit cursor?
- How to declare a cursor?
- How to fetch a cursor?
- How to close a cursor?