Home » SQL & PL/SQL » SQL & PL/SQL » procedure in another procedure (oracle 10g)
procedure in another procedure [message #381807] Mon, 19 January 2009 23:59 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,

can anyone guide me how to write 5 to 6 procedures in a single procedure like i am searching for a result through five procedures.
for performance factor i want to write it in a single procedure
Re: procedure in another procedure [message #381808 is a reply to message #381807] Tue, 20 January 2009 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>can anyone guide me how to write 5 to 6 procedures in a single procedure like i am searching for a result through five procedures.
You could always use vi to write the procedure.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.
Re: procedure in another procedure [message #381810 is a reply to message #381807] Tue, 20 January 2009 00:10 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Quote:
for performance factor i want to write it in a single procedure


What kind of performace?.

Thanks
Trivendra
Re: procedure in another procedure [message #381818 is a reply to message #381807] Tue, 20 January 2009 00:46 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What kind of performances increase do you expect merging 5 procedures into one?
Of course, if they are standalone procedures, it is a good practice to package them in... a package.

Regards
Michel

[Updated on: Tue, 20 January 2009 00:46]

Report message to a moderator

Previous Topic: Dynamic SQL with dynamic variable names
Next Topic: How do you avoid this sql warning?
Goto Forum:
  


Current Time: Tue Dec 06 08:09:40 CST 2016

Total time taken to generate the page: 0.17532 seconds