Oracle
  Home arrow Oracle arrow Page 4 - Oracle Stored Procedures
Dev Shed Forums 
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Sun Developer Network 
Dedicated Servers 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Actuate Whitepapers 
VeriSign Whitepapers 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ORACLE

Oracle Stored Procedures
By: Mooh The Cow
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 503
    2005-01-03

    Table of Contents:
  • Oracle Stored Procedures
  • Before you start
  • Write a procedure
  • Create a procedure
  • Run a procedure
  • Change a procedure
  • Debug a procedure
  • Drop a procedure
  • What you have learned
  • Further reading

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT

    Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

    Oracle Stored Procedures - Create a procedure


    (Page 4 of 10 )

    The SQL statement CREATE OR REPLACE PROCEDURE creates, compiles and saves a procedure on an Oracle database.

    You need the CREATE PROCEDURE system privilege to create a procedure in your own schema.

    Open SQL*Plus from Windows and log on to your database.

    From SQL*Plus, open your skeleton.sql file.
     
    SQL*Plus loads the contents of your skeleton.sql file into the SQL*Plus buffer or memory area and presents the SQL*Plus command prompt:

      1  CREATE OR REPLACE PROCEDURE skeleton
      2  IS
      3  BEGIN
      4    NULL;
      5* END;
    SQL>

    Execute the contents of the SQL*Plus buffer. Type a front slash and press <enter> like this:

    SQL> /

    SQL*Plus informs you the procedure has been created successfully and presents the SQL command prompt:

    Procedure created.

    SQL>

    Now your procedure is created, compiled and saved on your Oracle database.

    We have a procedure now, so let's run it. 
     

    More Oracle Articles
    More By Mooh the Cow


       · Hi i am madhu. Its a great article but if you have continued the artice with one...
       · Hi,This article is simply superb.The author didn't miss anything regarding Stored...
       · where I can find an example as easy to follow as thiswith parameters...
       · Helo , I am a beginner in Oracle. I must say that within short time i could grasp...
       · hi i read all the pages of stored procedure, it is very good for beginers,but...
       · Hello ! i m UDAI . i read this whole basic tut on STORED PROCEDURES.It's a nice...
       · very good basic instruction. it's the start of real pl/sql programming. 10 thumbs...
       · Hi, i am Sukumar Reddy.v the article on stored procedures is great but it will...
       · This article about stored procedure explained well and very easy to understand. My...
       · for only who do't know stored procedures at all.u have taken only skeleton and...
       · Hi Im senthil its really a good article I like very much step by step explanation is...
       · How to run stored procedure which has IN parameter
       · I can't believe people are responding positively to this article. Yes, it is well...
       · This article contains so little information regarding proceduresthis is not...
       · hi i read ur article and get that it's abest article for the oracle new cumers.and...
       · Hi, i am Ankur Agarwal, this article is well but it lacks various things like...
       · You have 10 thumbs?!?!?!? ;o)
       · hi , I m PRASHANT SRIVASTAVA this article is very good but should have some basic...
       · Hello, This is Radha. I am basic learner for stored procedure. This site...
       · Hi, I am venkat, It is very good, we request some more example procedures to...
       · Hi i am Niranjan, Nice article on Stored Procedures.........very clear and brief....
       · This is Mir, real quick and instant info about the subject with clear understanding,...
       · This article is very helpful for the PL/SQL beginers and easy to understand and will...
       · yes, i also thinks more the examples more the learning..good to see articles but...
       · Its is very easy to understand,who know little bit knowlodge in Sql,those are play...
       · What was explained here could have been accomplished only using Oracle SQL Developer...
       · This is an example... not a book or a class room. If you want more examples and in...
       · Hi i am Vara Rama Krishna, Nice article on Stored Procedures.........very clear and...
       · That was a lot of pages for a ridiculously small amount of information. I can't...
       · hi this is saurabh gulati, n i read all the pages of stored procedure, ...
       · store procedure in oracle allow programer to put data in a data base throw PL\SQL...
       · simply awsome and excellentshould have been good if continued furtherwith...
       · hi, i am Sunny Duggal.the article is excellent but more and more practical examles...
       · Hithis is a great article for the beginners and i really appreciate if you could...
       · Definintly not enough information here to do anything the slightest bit useful...
       · Hi, I am kaps. It is really greate article for the beginers.But it is not complete...
       · One glaring omission in this article is how to retrieve the definition of a...
       · Hi.. This article is really nice to read it. if more number of examples are there...
     

       

    ORACLE ARTICLES

    - Tuning PL/SQL Code
    - Debugging PL/SQL Code
    - Testing PL/SQL Code
    - Working With PL/SQL Code
    - Conditional Compilation for Oracle Database ...
    - Compile-Time Warnings for Oracle DB 10g
    - Compiling PL/SQL Code for an Oracle Database
    - Troubleshooting PL/SQL Code
    - Managing PL/SQL Code
    - Data Manipulation and More for HTML DB Appli...
    - Oracle Database Fundamentals
    - Adding Processes to HTML DB Applications
    - Adding Computations, Processes, and Validati...
    - Sub-templates and More with Oracle HTML DB
    - Focusing on Templates in Oracle HTML DB





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway