Home » SQL & PL/SQL » SQL & PL/SQL » Create several procedures
Create several procedures [message #282594] Thu, 22 November 2007 08:06 Go to next message
ALICIA_54
Messages: 2
Registered: November 2007
Junior Member
Hello,

I am a novice in PL / SQL, and I would like to know how we can create several procedure without that they are afterward replaced by the other one.

Thank you in advance
Re: Executing Procedure [message #282597 is a reply to message #282594] Thu, 22 November 2007 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't hijack a topic, create your own.

Precise your question, maybe with an example, I don't understand it.
And post your Oracle version.

Regards
Michel
Re: Create several procedures [message #282609 is a reply to message #282594] Thu, 22 November 2007 09:12 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Are you talking about Overloading?
Re: Create several procedures [message #282611 is a reply to message #282594] Thu, 22 November 2007 09:18 Go to previous messageGo to next message
ALICIA_54
Messages: 2
Registered: November 2007
Junior Member
yes of course!!! i want to overload a procedure

thank you !!!
Re: Create several procedures [message #282613 is a reply to message #282611] Thu, 22 November 2007 09:36 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Have a look here Smile
Re: Create several procedures [message #282663 is a reply to message #282594] Thu, 22 November 2007 22:49 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Overloading is possible only with gthe packages in Oracle.

Thumbs Up
Rajuvan.
Re: Create several procedures [message #282734 is a reply to message #282663] Fri, 23 November 2007 04:18 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
rajavu1 wrote on Fri, 23 November 2007 04:49

Overloading is possible only with gthe packages in Oracle.
Rajuvan.


Uh huh. I'm pretty sure that the link I posted covers that fairly comprehensively. Would you like to pointlessly repeat any other advice?
Re: Create several procedures [message #282756 is a reply to message #282734] Fri, 23 November 2007 06:01 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

pablolee wrote on Fri, 23 November 2007 15:48


Uh huh. I'm pretty sure that the link I posted covers that fairly comprehensively. Would you like to pointlessly repeat any other advice?



Not really ..

Actually some urls are blocked for us by our company . Unfortunaetly your url also in those blocked list Sad

DOn't ask me why such urls are blocked Laughing

Thumbs Up
Rajuvan
Re: Create several procedures [message #282766 is a reply to message #282756] Fri, 23 November 2007 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Unfortunaetly your url also in those blocked list

Oracle documentation is blocked???
Time to ask the rules being updated, doesn't it?

Regards
Michel
Re: Create several procedures [message #282776 is a reply to message #282594] Fri, 23 November 2007 07:08 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Yes Michal!

Not able to access many useful url Sad

@Rajuvan - We can ask for these right?

Kiran.
Re: Create several procedures [message #282785 is a reply to message #282594] Fri, 23 November 2007 07:37 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

I think better We wil recommond the same to our admin by showing your reply. Really confused why these urls are blocked !!!! Sad

Quote:

Oracle documentation is blocked???
Time to ask the rules being updated, doesn't it?


Michel , Thanks for your concern

Hi experts . all of your comments are well appreciated Smile

Thumbs Up
Rajuvan.


[Updated on: Fri, 23 November 2007 08:23]

Report message to a moderator

Previous Topic: External Table Error Trapping
Next Topic: strange behaviour when updating
Goto Forum:
  


Current Time: Thu Dec 08 10:25:29 CST 2016

Total time taken to generate the page: 0.09801 seconds