Oracle Stored Procedures

What you will learn

An Oracle stored procedure is a program stored in an Oracle database.

Now this is unusual – we expect data in a database, but not programs! However, you will soon see how useful this can be.

We often refer to an Oracle stored procedure as a procedure. You will learn to:

• write a procedure in Oracle's PL/SQL programming language using the Notepad text editor.
  
  
• create a procedure on an Oracle database, a process which will automatically compile and save the procedure.
  
  
• run a procedure stored on an Oracle database from the SQL*Plus tool supplied by Oracle.
  
  
• change a procedure by re-creating it on the Oracle database.
  
  
• debug a procedure by introducing, viewing and fixing a compilation error.
  
  
• drop a procedure, a process which will permanently remove a procedure from an Oracle database.

Next, you'll find out what you need to know before you start.