Oracle Stored Procedures

So what's this business with Oracle allowing programmers to put programs in databases? That's right. They're called Oracle stored procedures, and they're quite useful. Mooh the Cow walks you through writing, creating, debugging, and deleting a procedure.

TABLE OF CONTENTS:

By: Mooh The Cow

Poor Best

Rating:

/ 879

January 03, 2005

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

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.

Next: Before you start >>