aspose file tools*
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
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: 2510
    
  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 ?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: procedures vs stored procedures