Forum:

Oracle/OAS

procedures vs stored procedures

Rauhl Roy

Ranch Hand

Posts: 401

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

HI,

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

regards,
rahul.

Srinivasa Raghavan

Ranch Hand

Posts: 1228

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 1

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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: 2662

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Srinivasa Raghavan

Ranch Hand

Posts: 1228

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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 ?

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

A magnificient life is loaded with tough challenges. En garde tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser