Home » SQL & PL/SQL » SQL & PL/SQL » code practice (oracle plsql)
code practice [message #378760] Thu, 01 January 2009 05:28 Go to next message
swabhi
Messages: 4
Registered: December 2008
Junior Member
Is using nested procedures or function not a good coding practice????

is there is any cons of it????
Re: code practice [message #378763 is a reply to message #378760] Thu, 01 January 2009 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is.

Regards
Michel
Re: code practice [message #378832 is a reply to message #378763] Fri, 02 January 2009 01:18 Go to previous messageGo to next message
swabhi
Messages: 4
Registered: December 2008
Junior Member
Thanks for the answer...

but can you please elaborate why it is bad coding practice?
and what are the cons of it?
Re: code practice [message #378834 is a reply to message #378832] Fri, 02 January 2009 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, I meant it is a good practice.
Breaking the code in small, easy to read unit is always a good practice. However, not too small and not too numerous functions.

Regards
Michel
Re: code practice [message #378835 is a reply to message #378832] Fri, 02 January 2009 01:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://www.orafaq.com/forum/t/12203/2/
Re: code practice [message #378848 is a reply to message #378835] Fri, 02 January 2009 01:54 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Frank Naude wrote on Fri, 02 January 2009 08:22
See http://www.orafaq.com/forum/t/12203/2/

Hehe..
I was just about to make a reply stating that I don't like nested procedures.
Thanks to this link I don't need to Smile
Previous Topic: How can we do it. (merged)
Next Topic: How to Calculate the size of Database ,function,Procedure,Package etc.
Goto Forum:
  


Current Time: Thu Dec 08 10:37:58 CST 2016

Total time taken to generate the page: 0.08837 seconds