Home arrow Oracle arrow Oracle Stored Procedures

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.

  1. Oracle Stored Procedures
  2. Before you start
  3. Write a procedure
  4. Create a procedure
  5. Run a procedure
  6. Change a procedure
  7. Debug a procedure
  8. Drop a procedure
  9. What you have learned
  10. Further reading
By: Mooh The Cow
Rating: starstarstarstarstar / 879
January 03, 2005

print this article



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.

>>> More Oracle Articles          >>> More By Mooh the Cow

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: