What Is a Procedure

Home > Oracle > PL/SQL

What Is a Procedure

Q

What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions

✍: FYIcenter.com

A

A procedure is a named program unit. It consists of three parts:

Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required.
Execution Part - Defining execution logic with executable statements. Execution part is required.
Exception Part - Defining error handling logics. Exception part is optional.

Here how a complete procedure should look like:

PROCEDURE name (parameter_1, parameter_2) AS
  -- Declaration statements
BEGIN
  -- Executable statements
EXCEPTION
  -- Error handling statements
END;

2007-04-26, 5107👍, 0💬

How To Execute a Stored Procedure
How To Execute a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL> set serveroutput on; SQL> CREATE PROCEDURE Gre... 2007-04-26, 5410👍, 0💬

How To Create a Stored Procedure
How To Create a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example scrip... 2007-04-26, 5355👍, 0💬

How To Assign a Table Row to a RECORD Variable
How To Assign a Table Row to a RECORD Variable? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to assign a data row of that table to a RECORD variable, you need to define this RECORD variable to match the table column structure, then use the SELECT ... INTO ... 2007-04-27, 5349👍, 0💬

How To Insert a Record into a Table
How To Insert a Record into a Table? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example below: CREATE TAB... 2007-04-26, 5258👍, 0💬

How To Define a Variable to Match a Table Column Data Type
How To Define a Variable to Match a Table Column Data Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to de... 2007-04-26, 5159👍, 0💬

How To Define an Anonymous Procedure with Variables
How To Define an Anonymous Procedure with Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as show... 2007-04-26, 5109👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution... 2007-04-26, 5108👍, 0💬

How To Define an Anonymous Procedure without Variables
How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in S... 2007-04-26, 5084👍, 0💬

How To Define a RECORD Variable to Store a Table Row
How To Define a RECORD Variable to Store a Table Row? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in... 2007-04-27, 5082👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.