Home arrow Oracle arrow Page 10 - Oracle Stored Procedures

Further reading - 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.

TABLE OF CONTENTS:
  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
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

You can read more about Oracle stored procedures in the Oracle documentation. The following topics are covered:

  • Parameters: Our basic procedure accepts no parameters. You can declare input parameters to accept data, and output parameters to return data to the calling environment.

  • Variables: Again, our basic procedure contains no variable declarations, but you can declare any PL/SQL variable in a procedure, including characters, numbers, dates and Booleans.

  • Extracting data: You can use the SQL statement SELECT to extract data from an Oracle database and populate variables in your procedure.

  • Extracting lots of data: You can process batches of records in a procedure using cursors.

  • Transaction control: Manipulate data from within a procedure. Issue SQL statements INSERT, UPDATE and DELETE, and decide if you want to commit the changes, or if they should be rolled back.

Remember, if you don't feel like wading through documentation, visit the Developer Shed for fast answers. Let Mooh The Cow show you how!



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

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

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