• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

procedures vs stored procedures

 
Rauhl Roy
Ranch Hand
Posts: 401
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,

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

regards,
rahul.
 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by " Procedures " ? Is it a java code stored in Oracle ?
[ April 08, 2007: Message edited by: Srinivasa Raghavan ]
 
Phani Kumar Potturi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic