Home arrow Oracle arrow Page 5 - Oracle Stored Procedures

Run a procedure - 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



Run your procedure from the SQL*Plus command prompt with the EXECUTE command like this:

SQL> EXECUTE skeleton;

SQL*Plus assures you the procedure executed successfully:

PL/SQL procedure successfully completed.

The EXECUTE statement is easy and fast to type.

You can also run your procedure from within an unnamed PL/SQL block. At the SQL*Plus command prompt, it looks like this:

  2    SKELETON;
  3  END;
  4  /

PL/SQL procedure successfully completed.

By calling your procedure from within an unnamed PL/SQL block, you can even call your procedure twice, like this:

  2    SKELETON;
  3    SKELETON;
  4  END;
  5  /

PL/SQL procedure successfully completed.

SQL*Plus refers to the unnamed PL/SQL block when it says "PL/SQL procedure successfully completed." So even though we called the skeleton procedure twice, we only get one message back. So much for going the extra mile!

Now that we've run our procedure, what do we need to do if we want to change it? 

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