Home arrow Oracle arrow Page 9 - Oracle Stored Procedures

What you have learned - Oracle

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



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

Procedures are written in the PL/SQL programming language. You can use the Notepad text editor to write a procedure. Save each procedure with a .sql file name extension.

Log on to an Oracle database with Oracle's SQL*Plus tool. It submits SQL and PL/SQL statements to the Oracle database.

The SQL statement CREATE OR REPLACE PROCEDURE creates, compiles and saves a procedure on an Oracle database, regardless of whether the procedure contained compilation errors or not.

Run a procedure stored on an Oracle database from the SQL*Plus tool. Use the EXECUTE statement, or an anonymous PL/SQL block to call your procedure.

The clause OR REPLACE from the SQL statement CREATE OR REPLACE PROCEDURE overwrites an existing stored procedure on the Oracle database.

View a procedure's compilation errors with the SQL*Plus command SHOW ERRORS.
The SQL statement DROP PROCEDURE permanently removes a procedure from an Oracle database.

Would you like to find out more? Keep reading.

>>> 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: