| 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: 2344
|
|
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
ITIL foundation
|
|
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 ?
|
|
 |
|
|
subject: procedures vs stored procedures
|
|
|
0
