Oracle Stored Procedures
(Page 1 of 10 )

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.

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.
 

Next: Before you start >>
 

More Oracle Articles
More By Mooh the Cow

Comments On: Oracle Stored Procedures

· 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...   >>> Post your comment now!