Home » SQL & PL/SQL » SQL & PL/SQL » Advantage and disadvantage of Procedure
Advantage and disadvantage of Procedure [message #245436] Sun, 17 June 2007 03:31 Go to next message
dilippanda
Messages: 5
Registered: June 2007
Location: Bhubaneswar
Junior Member

Hi Gurus,

I want to know the advantage and disadvantages of a stored procedure in Oracle.

Please guide me.

Thanks,
Dilip
Re: Advantage and disadvantage of Procedure [message #245444 is a reply to message #245436] Sun, 17 June 2007 04:47 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you explain what you really need? Did you read the Coding PL/SQL Procedures and Packages chapter of the Application Developer's Guide - Fundamentals book?
Re: Advantage and disadvantage of Procedure [message #245547 is a reply to message #245436] Mon, 18 June 2007 02:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Advantages and disadvantages as opposed to what? Functions in Oracle? Stored procedures in SQLServer? ....
Re: Advantage and disadvantage of Procedure [message #245659 is a reply to message #245547] Mon, 18 June 2007 06:01 Go to previous messageGo to next message
dilippanda
Messages: 5
Registered: June 2007
Location: Bhubaneswar
Junior Member

I know the advantages/disadvantages of stored procedures over functions.

I want to know overall disadvantages and advantages of a stored procedure.
Please help me.

Thanks,
Dilip
Re: Advantage and disadvantage of Procedure [message #245672 is a reply to message #245659] Mon, 18 June 2007 07:17 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
[sarcasm ]
Ahh, the overall advantages and disadvantages, that's much clearer as to what you need now. You will find that info out by searching stuff
[/sarcasm]
Re: Advantage and disadvantage of Procedure [message #245682 is a reply to message #245659] Mon, 18 June 2007 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I know the advantages/disadvantages of stored procedures over functions.

What are they?

Regards
Michel
Re: Advantage and disadvantage of Procedure [message #245710 is a reply to message #245682] Mon, 18 June 2007 10:46 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.google.com/search?hl=en&q=advantage+and+disadvantages+of+a+stored+procedure+i&btnG=Search


Wink
Previous Topic: Sending email with attachment by oracle pl/sql
Next Topic: Weighted sum of intervals
Goto Forum:
  


Current Time: Sun Dec 04 00:12:41 CST 2016

Total time taken to generate the page: 0.14348 seconds