Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes Oracle/OAS and the fly likes procedures vs stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "procedures vs stored procedures" Watch "procedures vs stored procedures" New topic
Author

procedures vs stored procedures

Rauhl Roy
Ranch Hand

Joined: Aug 01, 2006
Posts: 401

HI,

may i know what the difference is between procedures and stored procedures.

regards,
rahul.
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
What do you mean by " Procedures " ? Is it a java code stored in Oracle ?
[ April 08, 2007: Message edited by: Srinivasa Raghavan ]

Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
Phani Kumar Potturi
Greenhorn

Joined: Apr 19, 2007
Posts: 1
Hi Rahul,

A normal procedure can or cannot have a return type, whereas a stored procedure should necessarily have a return type.

Phani
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2532
    
  10

Originally posted by Phani Kumar Potturi:
Hi Rahul,

A normal procedure can or cannot have a return type, whereas a stored procedure should necessarily have a return type.

Phani


Is this correct?


OCUP UML fundamental and ITIL foundation
youtube channel
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
Phani Kumar Potturi,

Can you just point out a link that shows how to create a procedure & a stored procedure in oracle ? What do you mean by a procedure ?

Am I missing something ?
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: procedures vs stored procedures